I have two tables Advisors and AdvisorRegions and the relation looks like this. One advisorRegion has many advisors and one advisor has one advisorRegion.
Now I want to show the name of the advisorRegion in the advisors-resource table.
I have the advisors_region_id as an foreign key in my advisor table
How do i do this in filament php v3.
I tried to look it up but found nothng interesting at all.
From the Displaying data from relationships section of the docs:
TextColumn::make('advisorsRegion.name');
Where advisorsRegion is the name of the relationship in your model
First define the relationship in the form section of the Model Resource.
Forms\Components\Select::make('vendor_id')
->relationship('vendor', 'company_name') // company_name or whatever field from the Vendor model
Then use the relation to display columns in table,
Tables\Columns\TextColumn::make('vendor.company_name')
->sortable()
->default(''),
Note: There should be a belongsTo relation defined in your model of the Model Resource. In this case
public function vendor()
{
return $this->belongsTo(Vendor::class);
}
within my Coupon model.
