Two Field Problem

[ianmuir]

Hi, I have 2 fields in a table "Project Name" and "project_ID".

so I could put "Asia" and "#78" no problem.

 

I need the "project_ID" to be locked to the project name.

So picking Asia would make the project ID field on a different layout automatically show #78

 

Can this be done?

Thanks

 

 

 

[mr_vodka]

Why arent you just using the ID field?

[ianmuir]

Sorry, I don't understand. can you show me an example?

 

Thanks

[mr_vodka]

you should use a value list and store the ID not the text.