form within a form

[Burnsie]

hello all.

I am rebuilding a database that I set up years ago and have therefore forgotten most of the stuff I learnt.

I have two tables, one for “personal details” and one for “test data”.

I have set up a relationship based on the link between staff numbers (these are unique to the staff member).

I have got access to set create a form for “personal details”.

What I would like is for my main "personal details” form, is to have a second "sub form" of the test data (in data sheet view) that can be used from the main "Personal details" form.

Any ideas how I go about this?

 

[Uncle Gizmo]

hello all.

I am rebuilding a database that I set up years ago and have therefore forgotten most of the stuff I learnt.

I have two tables, one for “personal details” and one for “test data”.

I have set up a relationship based on the link between staff numbers (these are unique to the staff member).

I have got access to set create a form for “personal details”.

What I would like is for my main "personal details” form, is to have a second "sub form" of the test data (in data sheet view) that can be used from the main "Personal details" form.

Any ideas how I go about this?

personal details
test data
staff member
3 tables?

Two subforms?

I'm not getting a clear message?

 

[Burnsie]

personal details
test data
staff member
3 tables?

Two subforms?

I'm not getting a clear message?

sorry, my bad. I have two tables; "personal details" and "testing". Both these tables have a "Staff member" ID field, which is linked. I think I’ve found the solution now anyhow....well, it seems to work at the mo, just need to sort out the report....(

 

[Uncle Gizmo]

Thanks for the update...

 

[Burnsie]

Don’t worry; I may still require your help....

So, I now how two forms, as mentioned above, with a relationship between the unique "staff number" in the "Personal details" table and the "staff number" in the "testing" table.

I have a main form with Personal details, with a testing subform. What I did before (and can’t work out how to do it now) is that each subform is linked to the main form. So, I would open the "personal details" form, enter the details and then go to the testing subform and enter the testing data. Then, if a client returns, I search for their personal details and only have to enter new testing details in the testing subform. Currently it seems like the subform is independent from the main form (i.e. Joe Blogg’s test data is not tied to Joe Blogg’s personal information)

Is my relationship incorrect?