Solved

Access Form This

Posted on 2014-01-12
8
510 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 30

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 30

Accepted Solution

by:
hnasr earned 375 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 31

Assisted Solution

by:Helen_Feddema
Helen_Feddema earned 125 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 30

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

785 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