Linking forms [?]

[johannaellamay]

I'm making a database for HR. I have an entire form of all the fields from one table. But I made another table for credentials because one employee could have more than one.

Now, the form:

I want to display the credentials fields on one of the tabs. I want it to look like a datasheet (datasheet view). But I don't know how to link it to the current employee ID. I've already set the relationships for the t_Employee and t_EmployeeCredential. I've already tried making a subform. But it just doesn't automatically reflect. I'm not sure if I'm making sense. I can't really explain it.

 

[Minty]

As long as you have the ecdEmployeeID set as child and eEmployeeID as master on your sub form it should work.
Make sure the ecdEmployeeID field is on the sub form even if it set to not visible.

 

[johannaellamay]

As long as you have the ecdEmployeeID set as child and eEmployeeID as master on your sub form it should work.
Make sure the ecdEmployeeID field is on the sub form even if it set to not visible.

Hi, I already linked the fields. But I don't want ecdEmployeeID to be seen. How do I set its visibility? And is it possible to make the font sizes smaller in datasheet view?

 

[Minty]

Hi, I already linked the fields. But I don't want ecdEmployeeID to be seen. How do I set its visibility? And is it possible to make the font sizes smaller in datasheet view?

Make your sub form a continuous form that looks "like" a datasheet rather than being a datasheet, then you can easily control what is visible and the font sizes, colours etc. for each field.

You can also easily then set the ecdEmployeeID field property to visible = No.

 

[johannaellamay]

Make your sub form a continuous form that looks "like" a datasheet rather than being a datasheet, then you can easily control what is visible and the font sizes, colours etc. for each field.

You can also easily then set the ecdEmployeeID field property to visible = No.

Okay got it! Thank you!