Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Use a macro to add a record to a table in Base

In the database I am making, I have a table "documents" and a table "categories". These two are joined to a third--"documentcategories"--by a primary-foreign key relationship.

On the data-entry form, I want to have a series of checkboxes, one for each category. When the user checks one, I want to add a record to the "documentcategories" table, associating the current documentID with that particular categoryID.

My question: Is this possible to to entirely in the form, or do I have to use a macro? Is it possible to do even with a macro? If so, how would I go about it?

Any help on this is appreciated. -AnthonyP

Use a macro to add a record to a table in Base

In the database I am making, I have a table "documents" and a table "categories". These two are joined to a third--"documentcategories"--by a primary-foreign key relationship.

On the data-entry form, I want to have a series of checkboxes, one for each category. When the user checks one, I want to add a record to the "documentcategories" table, associating the current documentID with that particular categoryID.

My question: Is this possible to to do entirely in the form, or do I have to use a macro? Is it possible to do even with a macro? If so, how would I go about it?

Any help on this is appreciated. -AnthonyP

click to hide/show revision 3
retagged

Use a macro to add a record to a table in Base

In the database I am making, I have a table "documents" and a table "categories". These two are joined to a third--"documentcategories"--by a primary-foreign key relationship.

On the data-entry form, I want to have a series of checkboxes, one for each category. When the user checks one, I want to add a record to the "documentcategories" table, associating the current documentID with that particular categoryID.

My question: Is this possible to do entirely in the form, or do I have to use a macro? Is it possible to do even with a macro? If so, how would I go about it?

Any help on this is appreciated. -AnthonyP