Checkbox fields and relational records ??

[KHaber]

I have set up checkboxes and value lists to populate my database in which I have many-to-many relationships with multiple choices for each field.

e.g. --

I have a table with PROGRAMS and a table with FORMULAS

Each PROGRAM can have multiple FORMULAS S so I set up a checkbox using a value list from FORMULAS...

Now I have each PROGRAM with several FORMULAS listed.

Now I also have a table with BOTANICALS

Each FORMULA can have multiple BOTANICALS so I set up a checkbox using a value list from BOTANICALS...

Now I have each FORMULA with several BOTANICALS listed.

But then Each BOTANICAL can have several THERAPEUTIC USES,

and I need to link each separate THERAPEUTIC USE to the BOTANICAL....and also to the FORMULA (together).

Do I need to dump the Checkbox field and enter separate records for each and every PROGRAM/FORMULA and each and every FORMULA/BOTANICAL and each and every BOTANICAL/THERAPEUTIC USE ?

Any ideas ?

If so, is there a Script to separate the records...or do I need to EXPORT to Excel and re-import as separate records?

Thanks, Karen

[LaRetta]

Hi Karen,

Your need seems a bit confusing. Please post your file (it can be an empty clone, zipped) or a simple demo file showing what you have. Then we can better envision what you're explaining for us.

And, is this tied to your other posts which I combined? Maybe you'll want to wait until you get the structure figured out (from the other post) before addressing your value list issue? Just a thought ...

LaRetta

[KHaber]

Thanks. Yes...the question is tied to my other post. I am going to check all of the really great replies and see how far I can get before addressing the checkbox/value list issue. Thank you for the suggestions.

Karen