Error

[Sarah Byrne]

I would suggest you do not use lookups at the table field level.


Make these true separate lookup/validation tables.

AddressTypeLkup
AddressTypeCode PK
AddressTypeName

TitelLkup
TitelId PK
TitelName

Not to sure what you mean by this. Its more the part information that I would need a look up for but either or I don't quite understand?

Thank you.

 

[Sarah Byrne]

Made it work and added in a sub form to show the list of all the parts that are on that job. There not too messy, I see what you mean now