Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access Form This

Posted on 2014-01-12
8
Medium Priority
?
525 Views
Last Modified: 2014-01-13
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
0
Comment
Question by:Rayne
  • 4
  • 3
8 Comments
 
LVL 31

Expert Comment

by:hnasr
ID: 39775847
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.
0
 

Author Comment

by:Rayne
ID: 39776558
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.
0
 
LVL 31

Accepted Solution

by:
hnasr earned 1500 total points
ID: 39776893
Rayne,

A design change may be required,
I think you don't need the Item_Country_JUNCTION table.

Check this version of database.
howDoesThisLook2014-2.accdb
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 31

Assisted Solution

by:Helen Feddema
Helen Feddema earned 500 total points
ID: 39777068
This is a many-to-many relationship.  See my sample database illustrating using forms to enter data in such a relationship.

http://www.helenfeddema.com/Files/accarch178.zip

Here is a screen shot of one of the forms:

Many-to-many relationships form
0
 

Author Closing Comment

by:Rayne
ID: 39777194
thank you hnasr and Helen :)
0
 
LVL 31

Expert Comment

by:hnasr
ID: 39777347
Welcome!
0
 

Author Comment

by:Rayne
ID: 39777365
thank you again hnasr :)
I owe you a Caramel frappuccino (Grande Size)
you are a life saver
0
 

Author Comment

by:Rayne
ID: 39777396
Here is another form question if you are interested :)
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28337329.html
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question