Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

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
0
Rayne
Asked:
Rayne
  • 4
  • 3
2 Solutions
 
hnasrCommented:
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
 
RayneAuthor Commented:
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
 
hnasrCommented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Helen FeddemaCommented:
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
 
RayneAuthor Commented:
thank you hnasr and Helen :)
0
 
hnasrCommented:
Welcome!
0
 
RayneAuthor Commented:
thank you again hnasr :)
I owe you a Caramel frappuccino (Grande Size)
you are a life saver
0
 
RayneAuthor Commented:
Here is another form question if you are interested :)
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28337329.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now