Linking records from two tables

[Nats]

How do you link the contents of certain records in one table to the contents of one record in another table and vice versa. Needs to be visible in form view

 

[Michael J Ross]

Create a query and join the two tables in the query, and then use the query as the source for your form.

 

[Nats]

Can you please elaborate a little, please? I need to be able to link a number of existing records in one table to a new record in a different table.

What I want is a subform showing all the records that are associated with the main form record and vice versa

 

[Michael J Ross]

Take a look at the attached query and form. Is this what you are after for your form? It allows you to add new records to either table and also links existing records and uses a subform.

Create the query and then use the Form wizard, it will create the form for you.

 

[Nats]

Thank you - getting there but whereas you have got a number of products being subform of a Product Type I also need Procuct Types to be a subform of Products - without duplications. Might make more sense if you were doing customers and products.

Customers interested in a product and
the same products that customers are interested in.

 

[Michael J Ross]

Hi,

You as you say need 2 forms, which are both based off the same query.

Have a look at the attached and look at the forms named Companies and Prods.

Companies lists all products bought by certain company and Prods lists each product and the company that bought it.

Have a go using the form wizard to create the forms using ProdType Query as the source.

 

[Nats]

Thank you for the response - just need to be able to add records in either of the forms and then I'm off and running. I presume that it will be possible to do "drop down" lists within the forms without creating duplicate entries?

 

[Nats]

Thank you for the response - just need to be able to add records in either of the forms and then I'm off and running. I presume that it will be possible to do "drop down" lists within the forms without creating duplicate entries?

Please can advise?

Thank you in advance for you help.