More than one table in one form

woeter

hello,

I want to use two tables in one form. The tables are tblUser and tblFile.
I want to show all the fields from tblUser (name, address, age,...) and some fields from tblFile (status, ID,...). The tables are related. The PK from tblUser is Nr and the FK in tblFile is user_ID. How can i show this in one form??

thx

Waldo

You can:
- use a subform
- extra textboxes in you tablebox, filling the data in code (OnAfterGetRecord)
- use flowfields

woeter

Which code should i fill in, in the onAfterGetRecord?
Could you give me an example?
Thx

kriki

Check also Form on two tables