Multiple dates for same client.

  • Thread starter Thread starter x
  • Start date Start date
X

x

i think what you should do is
create two tables
first, consisting of client name and a unique identifier

second table consisting of court date time...etc plus the
record identifier

then build a relationship between the two tables...

-----Original Message-----
I am trying to build a database. I work in a law firm and
Click to expand...
many clients have more than one court date. I have the
columns Court date, Court Time, Court room #. I think this
will be best for soting. I want to be able to have a
client with two sepeate dates but not repeat his name and
other information again. Is there anyway to do this.
 
Um Thanks but How do I do that? What would be an example of a unique identifier? How do I build a relationship between them? See I have never used Access before and am unfimlular with it's language.
 
you can use/create/insert a field on your first table
... you can use for example... autonumber field.
or a unique code for each client, depending on your need
it must be unique and no duplications (make it your
primary key)

the second table should have a field with the code but not
necessarily a primary key.

table 1 table 2
code name code date time
xxx xxxxxx xxx xxxxx xxxx
xxx xxxxx xxx

aaa aaaaaaa aaa aaaaa aaaaaa
aaa xxxxx xxxxxxx



-----Original Message-----
Um Thanks but How do I do that? What would be an example
Click to expand...
of a unique identifier? How do I build a relationship
between them? See I have never used Access before and am
unfimlular with it's language.
 
Back
Top