Basic problem

[pierre00438]

My problem is this one:

I have table named "Instrumentation" who's linked to a table "Project" by an ID and sometimes the instrument is assign to several project. Is it possible to make these links in only one field of the table "Instrumentation" ??? If not, what is the best way to solve this? Make several fields named "Project ID" and all linked it to the "Project" table.

Thank you very much

pierre00438

[vicrauch]

The "one" table should be the Instrumentation table, with the "many" being the Project table. But, if you can have one instrument assigned to many different Projects, and any Project can have many different instruments, then you would need a "link" table between this two tables. Basically, all you would need in this "link" table is two fields, the ID field from the Instrumentation table, and the ID from the Project table. That way, given a specific Project, you would be able to see what instruments are assigned to that project. Likewise, given a specific instrument, you could see which Project that instrument is assigned to.