hello all,

im a newbie at all of this and am trying to develop a product catalogue sales invoice system for a jewelry store/gallery. i have 3 files, contacts, products and sales. contacts and products are working fine, but i am having problems with sales. What i am attempting to do is:

locate product you wish to sell in catalogue (identified by id number) then hit a button "sell this item"

which opens the sales file, creates a new record, and pull in the id number from the catalogue files current record and use this as the key for the relationships for the other fields. is there some kind of pass variable option in scripting so i can automate the creation of a new record with the current id number from a separate file?

i have looked around but cannot figure out how to do this.

any help would be much apreciated.

hey all,

well that will teach me for not searching properly, i found the answer in a post by LaRetta

and it was as simple as a global field.

thanks LaRetta

thanks all