using script to add fields and containers

[feynman]

Hi there,

I am trying to develop a company project database and i have this problem. I have a database that contains projects within each record it holds information about that project including project manager, sponsor, start date and end date etc. It also holds the documents relating to that project i.e. a project mandate (document used in meetings to define the project for approval). What i am trying to do is creat a seprate table called 'meetings'. I want to be able to link from a record about a project to the meeting that it was approved in (So the meeting table will hold meeting documents like minutes etc). I can get it to create a table that contains the minutes and the agenda relating to a specific date but i need it to get all the documents from the project database that relate to that meeting date (i.e. all the documents that came up in that meeting - so it might be this mandate, that status report etc)

I know this is hard to explain but is there a way to insert fields and contains from one table into another table.

Any help or ideas will be appreciated.

Regards