Option group creating - help please

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi,

I am trying to put an option group on a data entry form
to choose a table and put entered records into respective
table.

Here is the scenario at hand:

i have two payment receival books, Book A and Book B.
Book A is for monthly payments we receive and Book B for
service charges, repairs, etc. these recipts we generate
using the A or B book has different recipt numbers but a
lot of the feilds are similar so I'm tring to put an
option group so that when "A" is selected record go into
table A and when B selected records go into table B. I
have tires samples in two different books but couldn't
make it to work. It seems that I don't know how to point
the option group to respective tables.

If yu can help directing me on a right track would be
very helpful and I thank you inadvance.

Regards,

Mike
 
Hi,

I am trying to put an option group on a data entry form
to choose a table and put entered records into respective
table.
Click to expand...

An Option Group has only numbers as its value. Would a Listbox perhaps
be more suitable?
Here is the scenario at hand:

i have two payment receival books, Book A and Book B.
Book A is for monthly payments we receive and Book B for
service charges, repairs, etc. these recipts we generate
using the A or B book has different recipt numbers but a
lot of the feilds are similar so I'm tring to put an
option group so that when "A" is selected record go into
table A and when B selected records go into table B. I
have tires samples in two different books but couldn't
make it to work. It seems that I don't know how to point
the option group to respective tables.
Click to expand...

I'd really suggest that you have a Payments table with a Book field;
include all the fields needed in either Book A or Book B (and just
leave the irrelevant fields NULL).
 
Back
Top