Hello there,
Some times things are so simple but we are not able to understand so become very difficult.
i have a table;
tbleTestInfo
TestID PK
TestName
FileID FK (From table fileid and filename) FiledID is hidden.
Note
when i go to a new table with TestNo to generate and create a form there so for TestID i put a code dlookp to choose the name of it on the next box and same i am looking for FileID which is already define in tblTestInfo to come up with each test.
If it works so only FileID appears which is not to seen as want to see filename. how to do that?
thanks
zee