Hi All. Grateful for any help here. I've attached a simple database where I have two main tables - Products and Packages. A package is a selection of products. I think the database structure is correctly normalised with a link table that joins a single package ID to multiple product IDs.
I've created a form using the form wizard to try and allow me to create a package and then in the sub-form, select the required products that make up that package. My problem is that the sub-form is just effectively giving me a read-only view of products that I have added to a package directly in table views. I can't find a way of making Product Name a drop down lookup of product names that I can select and save in the package.
Many thanks
David
I've created a form using the form wizard to try and allow me to create a package and then in the sub-form, select the required products that make up that package. My problem is that the sub-form is just effectively giving me a read-only view of products that I have added to a package directly in table views. I can't find a way of making Product Name a drop down lookup of product names that I can select and save in the package.
Many thanks
David
0 commentaires:
Enregistrer un commentaire