I have a problem I have 2 tables
one of clients
one of invoices

then when I create an invoice I want to have a dropdown to select the
client, but when I do it changed the name of the client with the id of
the other client, how can I get around this.

I just have less than a week I bought the program so go slow with me
, thanks,

JBarber

You will need to create a field in the invoice file named "Customer
Global" Assign this field a global storage and define your drop down
list to pull from your Customer File "Name" field. Your relationship
will need to be from the Invoice file to the Customer file using the
"Customer Global" filed to match the "Name" field in the customer file.


Then you will need to create a script that creates a new record in the
invoice file, uses the name from the "Customer Global" field and
automatically sets the Customer ID in the Invoice record to match that
of the Customer ID in the Customer File.

I know this seems a little in depth but it will work doing it this way.

Although.....


I would create a script from the "Customer" file that copies the
Customer ID, goes to the Invoice File, creates a new record and pastes
the Customer ID in the Customer ID Field in the Invoice file. Then you
can set up the Customer Name field in the Invoice file to lookup the
name from the customer file. The relationship would need to be set
using the customer ID in both files.

If you need more help let me know.

Good Luck,
Mark Valverde
MV Software
www.mvsoftware.net
Barber wrote: