T
Ted
I'm having difficulty building a db. I bought Office
2000 9 in 1 for Dummies and I'm still too dumb to figure
this out.
I understand how to build a table and a form. What I
don't understand is how I add records when the table
won't accept a field that has already been used. ie.: I
use a customer # to identify each record and I assumed
that this would be the relational field. How else can I
link information from one table to another?
Specifically: I have a business where I perform a
service on a periodical basis. I have no problem
entering the info in the table for the first service, but
when I try entering the next service (using the customer
# as the common field) the table rejects my data because
the field allready exhists. Do I have to build a new
table each time I perform the service?
2000 9 in 1 for Dummies and I'm still too dumb to figure
this out.
I understand how to build a table and a form. What I
don't understand is how I add records when the table
won't accept a field that has already been used. ie.: I
use a customer # to identify each record and I assumed
that this would be the relational field. How else can I
link information from one table to another?
Specifically: I have a business where I perform a
service on a periodical basis. I have no problem
entering the info in the table for the first service, but
when I try entering the next service (using the customer
# as the common field) the table rejects my data because
the field allready exhists. Do I have to build a new
table each time I perform the service?