Computing.Net > Forums > Database > MS Access Data Entry Complexity

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MS Access Data Entry Complexity

Reply to Message Icon

Name: mickymouse
Date: April 16, 2007 at 06:26:22 Pacific
OS: Win XP
CPU/Ram: 256 MB
Comment:

I'm trying a small database program using MS Access 2003.
I have a number of tables ( 5 in number ) as one side related to a single table as a many side. This means the many side table has 5 foreign keys added to its fields. I created a form for data entry from the many side table. Access is asking me to fill the foreign keys first if I'm going to proceed to the next record.
How could I handle these foreign keys - any one any idea, please!




Sponsored Link
Ads by Google

Response Number 1
Name: rousou
Date: May 3, 2007 at 06:41:12 Pacific
Reply:

Use the subform option (use the tab option to show all of the tables in the minimum space - 1 subform on each tab).

main form will be the main table, subforms the 5 tables. when you create the subform it will ask for a link between main and sub, use the foreign key of each table.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: MS Access Data Entry Complexity

MS Access 2000 annoys me www.computing.net/answers/dbase/ms-access-2000-annoys-me/104.html

How to merg fields in MS Access www.computing.net/answers/dbase/how-to-merg-fields-in-ms-access/461.html

Add records to .dbf database thru MS Access www.computing.net/answers/dbase/add-records-to-dbf-database-thru-ms-access/605.html