Creating multiple records with a button

[Ronzues]

Hi. I am in need of some help with this one.

I am needing some ideas on how to create new records based on a found set of contacts and update them all with the same info.

For example:

I have a contact database and I will find a group of people then I will have a button that will take me to another layout where there will be a couple of fields such as "Date" and "Comments" and I would like to enter the data once in each field and press a button and have it create all new records based on the found set and auto enter the data from the fields in the records and in the 2 fields that I updated.

Can somebody come to my rescue?

[Søren Dyhr]

Although your skills level tells otherwise, would someone who had been deling with relational databases just for a short while, rather have a complicated fracture on his/her leg than abide this:

I am needing some ideas on how to create new records based on a found set of contacts and update them all with the same info.

The crucial thing here is "same info" which is what we all strive to prevent. This is way into a many to many relation, where one and same info is availiable thru the relation, but certainly not stored in multiple!

Investigate this article and template:

http://www.dwaynewright.com/afa/examples/manytomany.html

So if you would assign a found set to something is either looping or a scripted replace of KEYVALUES and not real data, that have to be done. Similar - since you're on FM5 is a crucial thing to get to know this:

http://www.dwaynewright.com/afa/articles/found6/foundd8.html

--sd

[Ronzues]

Is there anyone that can give me some helpful info? Sorry Soren but I didn't understand much of what you wrote.

[LaRetta]

Much depends upon what the information is! For instance, I can see having a found set of Contacts and wanting to create a set of Activities (in the Activities table), inserting the ContactID, DateDue and a Comment such as, "Follow up on last order." Or, if you generated a mailing for each of the Contacts, recording the MailSent date and a Comment about the envelope contents. Even a straight comment in the Comments table would make sense. However, as Soren indicates, this type of request can also imply underutilizing a good relational structure.

It would be quite helpful to know the purpose. Your generic description does not provide us with the vision necessary to help you. Please also indicate which table will hold this new information.

LaRetta