Option group creating - help please

[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

 

[John Vinson]

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.

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.

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).