Access2K Design question.

[Guest]

I am running a small database that tracks customer info and links it with
their cash transactions. I am attempting to add a second cash draw that will
operate independent of the first draw but still access the customer info from
the existing customer table. I also want to be able to report a daily
balance sheet from each drawer independently and report a balance sheet
tabulating both drawers together.

The easiest way would be to add a check box to the original transaction
table to indicate which drawer is being used, but mistakes may arise with the
users mixing up which drawer they are using.

I tried creating a second transaction table (which runs a second transaction
autonumber) but am unable to do the combined balance sheet because I am
unable to query the data due to the pesence of two autonumbers (one from each
table). I am stomped. Any help would be greatly appreciated.

 

[nanne]

ceate a new new column in your draw table:
cashdraw ( 1 or 2)

 

[Guest]

You could back up a step to the point where you had a check box.

Make the checkbox hidden, now whatever you were going to use to open the
cash draw 2 transaction table, use it to set the value of the checkbox
instead.

Quick & dirty I know, but it keeps the job running while a more elegant
solution is written.

Alec

 

[Guest]

Thank you for your suggestion. I think you put my (feeble) brain straight.
I may be able to set the value upon opening the form. Thank you again. I'll
let you know how I make out with the problem.