Table Relationships
hi Folks,
Im putting this help request out to the community as ive burned up a lot of hours trying to solve the issue.
Im currently building a furniture commerce site in php using the Super Suite and have information stored in multiple mySQL tables that I would like to pull into the results.
Im looking to pull in the information for a particular range from 1 table called prodrange and the associated products in this particular range from a table called products
The field im referencing to is ProdRangeID in both tables.
I need to be able to choose a range and have the ranges' associated products display on a page.
I can do this without issue if everything was stored in a single table but for practical reasons i need to have multiple tables working in relation to each other.
Do I need to create a variable above what Dataassist generates in order for this to work?
Any help will be greatly received and a virtual beer sent on to you from me. :-)
Thanks
Suggs