Autocreate records from continuous form

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top