Table/Form

[jadefury]

I already have two tables setup with relationships setup for each table with primary keys. I want the primary table to fill in data already on the first table like last name, first name, and employee ID#. I have the forms connected already with a button/macro. I don't have room to create a subform that is why I have to create two seperate forms. Thanks in advance for the help!

 

[SOS]

You don't need to store more than the employeeID in the second table. You do not store redundant data (just the foreign key). See this about normalization to see more about this.

 

[jadefury]

So this is what I am trying to do. I need to add a second form because I have no room on the first one. I need the second form to reflect the same data from the first table and the forms must match with last name, first name, and employee ID #. I am trying to make it to where it is a second page to the primary form.

thanks!

 

[SOS]

You can use UNBOUND text boxes for the LastName, FirstName but then you can open the form using OpenArgs to pass the value of the EmployeeID to it. And then if you use a combo box you can have all the fields there and just refer to it using the unbound text box control sources (like: =[ComboName].[Column](1) )