It's in the Equipment_Spec table (Equipment table that we have been referring to). I'd like to attach a copy of the db but it's 4MB is larger then the 2MB limit. The existing data that's in the table still have the description of the field's (cate, item, type) but any new data would have the code like you said.
Question Combine fields into one field in same record
- Thread starter mayestom
- Start date
I think I’m starting to get it. I think. So I take Equipment_code out of Equipment table and I would put it in my Project table and have a lookup on it that has a record source of the query (that you told me to make) that concatenates the code for me. And places that resulted concatenation in the Equipment_code field which is now in Project table. Am I getting it know?
So the Project_Equipment field in project form record source the EquipmentCodes query. And every time I select a piece of equipment that would be associated with a project, only the ID number would go into the Project table along with the project it’s associated with. But the code is what’s displayed. So the code only exists on the form and in the query. It’s never entered into a table field. Am I getting it now?
Yes. Now for my next trick I will read your mind:
How do I assign multiple pieces of equipment to a Project?
For that you need a junction table: http://en.wikipedia.org/wiki/Junction_table
How do I assign multiple pieces of equipment to a Project?
For that you need a junction table: http://en.wikipedia.org/wiki/Junction_table
No problem, but I do recommend you get your tables correct before you go building forms and reports on them. Tables are the foundation of your database, getting them right is the first step of building a database.
Similar threads
