Solved

Access Form This

Posted on 2014-01-12
8
511 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
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 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