Using linked tables in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have 3 tables.
Stock
Accesoires
and a table to link them as a record in stock can have multiple accesoires.

Now I want a form where I can see a record from the table Stock, with all
the Accesoires that belong to that record.
How can I do this? Is this possible?
It doesn't matter in what kind of object the data is displayed, I just need
it displayed.

The relationship looks like this, for if it wasn't clear:

Stock.ID -- linkTable.StockID
linkTable.AccesoiresID -- Accesoires.ID

I hope someone can help.
 
I thought it would be

Record -> accessories

and put the stock location number in the "record" table? Or have I
misunderstood?
 
No, I need to see in a form a record from the table Stock and all Accesoires
belonging to that record.
 
Use the form creation wizard, select all the appropriate fields. The "stock"
fields will go in the main form and the "accessory" fields will go in the
subform. You will get a list of all accessories for each stock record.
 
Thank you! I have what I want now!!
The problem was that at first the wizard didn't want to use a subform,
because of relation problems. But I got it to work!
 
Back
Top