N
noodnutt
G'day ppl,
Here's my dilemma, the db is for a boarding kennel.
I am trying to combine the owners uniqueID with each of their animals e.g
Client1 has 2 dogs, so in order to identify their dogs, I need something
like 1:1, 1:2 etc
Client69 has 12 dogs, eg
69:1 thru to 69:12
this way each animal will be tied directly to it's owner in a round-about
way, question is, how can I automate it so that when I come to entering the
animals details, this number will generate.
P.S. I already pass the owners ID automatically when the animal form opens
TIA
Mark
Here's my dilemma, the db is for a boarding kennel.
I am trying to combine the owners uniqueID with each of their animals e.g
Client1 has 2 dogs, so in order to identify their dogs, I need something
like 1:1, 1:2 etc
Client69 has 12 dogs, eg
69:1 thru to 69:12
this way each animal will be tied directly to it's owner in a round-about
way, question is, how can I automate it so that when I come to entering the
animals details, this number will generate.
P.S. I already pass the owners ID automatically when the animal form opens
TIA
Mark