If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms design for one-to-one tables
What's the best way to design a form to populate a table (tblPhase2), which
is related on a one-to-one basis with another table (tblPhase1) which has already been populated. I would like the user to enter the data from three fields (which will be unique to only onerecord) from tblPhase1 and then fill in frmPhase2, linking the two together without ever seeing the primary key fields. I have tried using combo boxes based on a query, but I just can't make it work. Suggestions? |
#2
|
|||
|
|||
Forms design for one-to-one tables
Create a subform out of tblPhase2 on the form used for populating tblPhase1.
-- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Babe in the Woods" wrote: What's the best way to design a form to populate a table (tblPhase2), which is related on a one-to-one basis with another table (tblPhase1) which has already been populated. I would like the user to enter the data from three fields (which will be unique to only onerecord) from tblPhase1 and then fill in frmPhase2, linking the two together without ever seeing the primary key fields. I have tried using combo boxes based on a query, but I just can't make it work. Suggestions? |
#3
|
|||
|
|||
Forms design for one-to-one tables
There's a sample database at
http://www.mvps.org/access/tables/tbl0013.htm that should help. -- Joan Wild Microsoft Access MVP Babe in the Woods wrote: What's the best way to design a form to populate a table (tblPhase2), which is related on a one-to-one basis with another table (tblPhase1) which has already been populated. I would like the user to enter the data from three fields (which will be unique to only onerecord) from tblPhase1 and then fill in frmPhase2, linking the two together without ever seeing the primary key fields. I have tried using combo boxes based on a query, but I just can't make it work. Suggestions? |
#4
|
|||
|
|||
Forms design for one-to-one tables
That will do it. Thanks for your help!
"Joan Wild" wrote: There's a sample database at http://www.mvps.org/access/tables/tbl0013.htm that should help. -- Joan Wild Microsoft Access MVP Babe in the Woods wrote: What's the best way to design a form to populate a table (tblPhase2), which is related on a one-to-one basis with another table (tblPhase1) which has already been populated. I would like the user to enter the data from three fields (which will be unique to only onerecord) from tblPhase1 and then fill in frmPhase2, linking the two together without ever seeing the primary key fields. I have tried using combo boxes based on a query, but I just can't make it work. Suggestions? |
#5
|
|||
|
|||
Forms design for one-to-one tables
Thank you. I appreciate your help!
Oh, and I pick strong and cheap. "Babe in the Woods" wrote: What's the best way to design a form to populate a table (tblPhase2), which is related on a one-to-one basis with another table (tblPhase1) which has already been populated. I would like the user to enter the data from three fields (which will be unique to only onerecord) from tblPhase1 and then fill in frmPhase2, linking the two together without ever seeing the primary key fields. I have tried using combo boxes based on a query, but I just can't make it work. Suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why Control tools used in forms revert to design mode | Susanne | General Discussions | 1 | December 5th, 2005 07:14 PM |
Table(s) Design | dar | Database Design | 1 | June 14th, 2005 01:56 PM |
using queries instead of tables for forms | JimmyD | New Users | 1 | March 16th, 2005 03:04 AM |
Forms: using two tables and a combo box | pepenacho | Using Forms | 2 | February 5th, 2005 08:07 PM |
Minor drag adjustment when design forms | Jane Humbrey | Using Forms | 4 | August 13th, 2004 06:01 AM |