Column 'name' in field list is ambiguous with HasManyThrough

if you are using a select statement, you may need to use tablename.name

Do you have the hasMany() relations set up between stores/categories and categories/subcategories?

Thanks @Snapey

I'm not sure I follow. I'm not using select statements on any of the hasManyThrough relationships. Do you think I need a select statement in this case?

When you get this duplicate name, what are you doing? You only show the relationship above, not what code is calling the relationship.

Thanks @bwrice

Yes, I do. I'm able to use $store->categories, $category->store and $subcategory->category. But I'd like to generate a list of $store->categories->subcategories, giving me a list of all subcategories related to a store. I know how to write it in MySQL but I was trying to follow the Laravel format. It seems it would work fine if I didn't have ambiguous names in both related tables.

Hey @Snapey

I'm calling $store->subcategories() in a blade template, specifically in a select drop down so I wrote it as $store->subcategories()->lists('name', 'id'). I get the error in my relationship definition.

In your controller, preload the subcategories with with

$store=Store::with('subcategories')->find(1);

or whatever

then in your select

@foreach($store->subcategories as $subcategory)

    <option value="{{ $subcategory->id }}">{{ $subcategory->name }}</option>

@endforeach 

This did the trick:

$store->subcategories()->lists('subcategories.name', 'subcategories.id')

When I remove "subcategories." before "name" (how I had it) I get the ambiguous field error.

Thanks for your help @Snapey and @bwrice. I appreciate it!

lists() was deprecated some time ago in favour of pluck()

@Snapey Really? I didn't know. I'll check out pluck now. Thanks for the heads up.

pluck() works great. Thanks @Snapey.

in which file/class you put this syntax $store->subcategories()->lists('subcategories.name', 'subcategories.id')?

Thank you @snapey !!!!!! Remind me to buy you a beer at a future Laracon :D