Autocreate records from continuous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a continuous form based on a query that gives a list of contacts,
which I then use for a mail merge.
Now I wish to know whether it is possible for me to add a field in the form
header where the user can select a date and a type which will then create new
records in a new table that would be called communication ?

Here's how my DB kinda looks...

Contacts
---------------
ContactID
ContactName
....

Project
----------
ProjectID
ProjectName
....

Calls
-----------
CallID
ContactID (relation)
ProjectID (relation)
....

Goal would be to have a new table :
Communication
----------------------
CommunicationID
ContactID
ProjectID
Date
Type (combo)

So that via the continuous form I create records automatically so that I can
link the sent fax info.
Is that possible and if yes... How ?

Thanks,

Ben
 
Back
Top