Data Assist Wizard with multiple tables
I've got a bit of a newbie question here so please be patient. I don't have any PHP experience and very little MySQL, but I'm working on that :)
I have an Items table with these columns:
ItemNumber (key)
ItemName
ItemDesc
ItemPrice
MSRP
and a Color table with these columns:
Color_ID (key)
ItemNumber (matches the ItemNumber field in the Items table)
Color
I've created both tables using MySQL Administrator and I haven't created any relationships between them.
Basically the Color table stores the color information for the items in the Items table. We have several products that have multiple colors so that's why I set up a separate table for that. I'll need to create more tables for things like sizes and manufacturer, but I wanted to get two tables working and then go from there to make sure I understand the process.
When I step through the data assist wizard I can only define a connection to one table as far as I can tell. How would I use data assist to pull data from more than one table at a time?
Thanks!