Table issue

[Frisco Depot]

I have a table (Table A) that contains employee records like EmpID, name, address, city, state, zip and the like.
On the Form for Table A, I need a control button that opens the Form for a second table (Table B) to enter several fields of additional information for the employee that is the current record in Table A's form. Not every employee
will have additional information.

Any help will be appreciated.

[JustJim]

@Frisco Depot
Hi,

If you base your form on a query that correctly links tables A and B then your form will show and accept data for each table just fine.

Jim

[Frisco Depot]

Thanks for your quick reply - am trying that right now.

[Frisco Depot]

Hi Jim,
The query is working fine if the second table already has a record in it for that employee (AppID). If I open the second table form that is based on the query there are no errors and the form accepts the information but does not create a new record in the second table with the new information.

Thanks,
Gregg

[Frisco Depot]

Hi Jim,
I think I got it.
I had to change the Control Source for the AppID field in the second table form to what the query called it and put in a Default Value of the AppID from the first table form.

Thanks,
Gregg

[JustJim]

@Frisco Depot
Hi Gregg,

Sorry about the delay, I don't think my subscription notifications are working properly.

I thought you were talking about only one form, which I suggested should be fed by a query linking your two tables. You should probably also go into "Relationships" and link your two tables there. You probably need to read up on "Cascade update" and (to a lesser degree) "Cascade delete".

Let us know how you get on.

Jim