|
Hi there,
I've got a problem that I'm sure is simple to someone with more experience.
I have three tables: clients, tools and projects. Two of the fields in projects are linked to clients and tools (each project has a client and a tool). I would like one field in the "projects" table to be a combination of some of the info from all three tables.
For example:
client: bob (in the "client" table)
tool: 25 (in the "tools" table)
project#: 72 (in the "projects" table)
I would like one field in the "projects" table to automatically be filled with "bob25-72".
I've seen that I can combine things in a query but the relationships see to fall apart once I try and use this generated number in other tables. is there any way to fill this number directly in a table automatically without getting macros involved?
| 
