I am trying to create a relation between a contact and invoice
database through a Customer ID. Does the ID have to be numeric or can
it be alpha numeric? Also, how do I invoke the field to present
options when I go to enter an ID, as one might see when entering a
Company name (auto-fill?).
Thanks
> I am trying to create a relation between a contact and invoice
> database through a Customer ID. Does the ID have to be numeric or can
> it be alpha numeric?
You can do both. Make sure the ID is unique.
> Also, how do I invoke the field to present
> options when I go to enter an ID, as one might see when entering a
> Company name (auto-fill?).
Not sure what you want to do here. I leave this to native English
speakers.
--
http://clk.ch
"Christoph Kaufmann"
news:1i6sdwr.18mhaa995zryiN%clk@freesurf.ch...
>
>
>> I am trying to create a relation between a contact and invoice
>> database through a Customer ID. Does the ID have to be numeric or can
>> it be alpha numeric?
>
> You can do both. Make sure the ID is unique.
>
>> Also, how do I invoke the field to present
>> options when I go to enter an ID, as one might see when entering a
>> Company name (auto-fill?).
>
> Not sure what you want to do here. I leave this to native English
> speakers.
> --
> http://clk.ch
Generally you are better of with an automaticaly generated ID. No users
involved, no chance of errors. So for a companyname ID I would use an
auto-generated ID like CN000001, auto-increment it by 1. Leaving enough room
for 999999 companies before running ionto trouble. If you think you'll ever
going to hit that number, just add a zero or two.
Keep well, Ursus
buck.matthew74@yahoo.com wrote:
I am trying to create a relation between a contact and invoice
database through a Customer ID...
Also, how do I invoke the field to present
> options when I go to enter an ID, as one might see when entering a
> Company name (auto-fill?).
>
> Thanks
>
I am guessing that you want to assign a Customer to the invoice?
You don't have to enter the CID directly, meaning you don't have to type
in the CID, you can enter the customer name and have the CID entered
via a lookup (i.e 2 fields, CustomerName, CID)
Two fields, CustName and CID in Invoices,
create a rel from Invoice to Customer using a constant to constant (e.g.
a calc in each that equals 1. Make it a number calc, there are
situations where an auto-enter calc does not work as expected.
Define a value list CustNames, using first field (only) from Customers,
CustName. Use related values starting from Invoices.
Attach the value list CustNames to the name field , defined as a
Drop-Down List with auto complete.
Create a rel from Invoice::CustName to Customer::CustName, and use this
to define the CID field in Invoice, as lookup to return the CID value.
Alternately, you can use a value list and attached as a POP-UP MENU to
the CID field, on the INVOICE layout. This allows just one field, the
CID, to be used. The ID value is entered, but the name text value is
displayed.
The value list is defined to display values from Customers:
first field: ID
second field: Name
to include all values
and show only values from second field
A relationship between Customer and Invoice is not required.
Quite why this works, I have never figured out, but it does, and
contributes to normalisation.
If anyone has opinion or insight on this, including negative, I would be
interested to hear.
Chris