Table with look-up columns

[Tallica]

I have 2 tables in a database. 1 is a for projects and one is for contacts.

I have inserted a look-up column in my projects table that looks for a contact name from the contacts table. I want additional fields in the projects table to be filled with values from the contacts table based on the look-up column selection and I can not figure it out.

Any help would be greatly appreciated.



Thanks

[RuralGuy]

With forms not an issue, but users should not see tables and you should not be using Lookup Fields.

[Tallica]

User are not seeing the tables or forms directly from access. Users ar accessing the DATA through a visual basic exe.

[RuralGuy]

All the more reason not to use a Lookup Field.