M
mbp
Hi
Got two questions, I hope someone can help me with
Got a main tabel with a "keyword"-field. Each record can have several
keywords and these keywords are stored in a related subtable.
This subtable is again related to a table containing a list of keywords. The
keyword table only has one column and the property limit-to-list is set to NO.
I have made a form containing fields from the main table and a subform where
the keywords can be chosen.
My questions are as follows:
1. I want the user to be able to enter a keyword not on the list AND at the
same time get the entry saved in the keyword-table. How do I do that?
2. How do I make a query giving me all the data from a record in the main
table plus all the related keywords from the subtable.
Thanks for you help!
Got two questions, I hope someone can help me with
Got a main tabel with a "keyword"-field. Each record can have several
keywords and these keywords are stored in a related subtable.
This subtable is again related to a table containing a list of keywords. The
keyword table only has one column and the property limit-to-list is set to NO.
I have made a form containing fields from the main table and a subform where
the keywords can be chosen.
My questions are as follows:
1. I want the user to be able to enter a keyword not on the list AND at the
same time get the entry saved in the keyword-table. How do I do that?
2. How do I make a query giving me all the data from a record in the main
table plus all the related keywords from the subtable.
Thanks for you help!