[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Access Form This

Posted on 2014-01-12
8
Medium Priority
?
519 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

656 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