asked on

Access Form This

Hello All,

Here is a simple database design that I have completed. Please look at Form1. Now I need a form (or a sub form within a form) in such a way so that users can start filling up the table [Item_Country_DisPipe_JUNCTION]

thank you
howDoesThisLook2014.accdb

Hamed Nasr

If you look at the relationships diagram you notice the required table, Item_Country_DisPipe_JUNCTION, is a link between tblDistPipeline and Item_country_junction.
You need to fill the last one, Item_country_junction, first.
Then you create a form for the Item_Country_DisPipe_JUNCTION with othe link keys as combo boxes populated from the linked tables.

I think you need to remove Junction from the names.

Rayne

ASKER

thank you hnasr, sure. I was thinking is it possible to use a kind of query or something so that users didn't have to fill in that table first [ Item_country_junction] ?

Please let me know.

ASKER CERTIFIED SOLUTION

Hamed Nasr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION