Lookup Tables and Multiple Values

I currently have a table (t_Items) which has a multiple value field
(ItemRequire). I am going to break the multiple value field into a seperate
related table, i.e. each record in t_Items will have multiple related records
in my new table t_ItemRequirements. The t_Items table is being used as a
lookup table for another table (t_Daily), with the lookup field being Items.
I have not been able to grasp how I can record the data I am interested in.
In a form for t_Daily, I want to be able to select one of the 'Items' and
then have the related ItemRequirements pop-up. I would then want to be able
to record which of these related ItemRequirements have been done. Basically,
I want to record if all requirements for an item have been met for each
instance of an item. I am not sure how I would have to set things up to
acheive this. Any suggestions/assistance would be greatly appreciated.
Thank you in advance.

Brian

I have not received any responses to this thread,so I assume I am being
unclear. In short, I have a table that will be used as a lookup and another
table that is linked to this table (a multivalue field which has been broken
into its own table). When the lookup table is used in a form, I want to be
able to record if its related records in the related table have also
occured...This does not seem any clearer, but any help would be greatly
appreciated. Thank you in advance.

Brian

"Brian Carlson" wrote:

I currently have a table (t_Items) which has a multiple value field
(ItemRequire). I am going to break the multiple value field into a seperate
related table, i.e. each record in t_Items will have multiple related records
in my new table t_ItemRequirements. The t_Items table is being used as a
lookup table for another table (t_Daily), with the lookup field being Items.
I have not been able to grasp how I can record the data I am interested in.
In a form for t_Daily, I want to be able to select one of the 'Items' and
then have the related ItemRequirements pop-up. I would then want to be able
to record which of these related ItemRequirements have been done. Basically,
I want to record if all requirements for an item have been met for each
instance of an item. I am not sure how I would have to set things up to
acheive this. Any suggestions/assistance would be greatly appreciated.
Thank you in advance.

Brian

Please disregard this post. I did not receive a response, but I have
reposted a similiar question in Utter Access under the thread name "Using
Lookup table and related tables as Lookups..." Any help would be appreciated.

Thank You,
Brian

"Brian Carlson" wrote:

I have not received any responses to this thread,so I assume I am being
unclear. In short, I have a table that will be used as a lookup and another
table that is linked to this table (a multivalue field which has been broken
into its own table). When the lookup table is used in a form, I want to be
able to record if its related records in the related table have also
occured...This does not seem any clearer, but any help would be greatly
appreciated. Thank you in advance.

Brian

"Brian Carlson" wrote:

I currently have a table (t_Items) which has a multiple value field
(ItemRequire). I am going to break the multiple value field into a seperate
related table, i.e. each record in t_Items will have multiple related records
in my new table t_ItemRequirements. The t_Items table is being used as a
lookup table for another table (t_Daily), with the lookup field being Items.
I have not been able to grasp how I can record the data I am interested in.
In a form for t_Daily, I want to be able to select one of the 'Items' and
then have the related ItemRequirements pop-up. I would then want to be able
to record which of these related ItemRequirements have been done. Basically,
I want to record if all requirements for an item have been met for each
instance of an item. I am not sure how I would have to set things up to
acheive this. Any suggestions/assistance would be greatly appreciated.
Thank you in advance.

Brian