Same combo box populating different fields

[timbits35]

Hi,

I have a combo box in a table tblTypeResultList that lists decision results- example - awarded, denied, allowed and has fields ResultID, Resultdesc.

I also have another combo box in tblTypeCase that lists types of case example - costs, jurisdiction, governance and has fields TypeDisputeID, TypeOfDisputedesc

These 2 combo boxes are used in the main case table tblCase as foreign keys.

Right now each case only has 1 type of dispute and 1 result.

Example Case 56, costs, awarded, 07/21/2016

I would now like to have several types of disputes and decisions for each case.

Example Case 56, costs, awarded, 07/01/2016
Case 56, jurisdiction, denied, 07/13/2016
Case 56, merits, appeal allowed, 07/21/2016

I DO NOT want to interfere with any of the information that already exists in tblCase, as there are queries and calculations and I need to keep these as is. Can I use the same combo boxes to populate new and different fields in a new table? For example I would create a new linked table called tblCase_Decision to allow the many side of the equation which would have fields

CaseID (foreign key from case table)
Descndate - date field
DescnResultID - foreign key
DescnTypeDisputeID - foreign key

Thank you

 

[MarkK]

Can I use the same combo boxes to populate new and different fields in a new table?

What do you mean, "the same combo boxes?" No, this is a new table, right, so they will be different combo boxes. But what do you mean by the same? The same settings? Not sure I understand the question.

 

[timbits35]

Hi,

I hope this clarifies things.

I would like to use the same tables tblTypeCase and tblTypeResultList as a record source for 2 different tables. Think of it as having a list of provinces in a table and needing to use that table as a record source for more than 1 table.

Thanks again

 

[MarkK]

Do you mean you have lookup fields? Tables don't have other tables as "record sources." Generally lookup fields are not recommended at the table level, rather it is more common to add those lookups to queries, or to forms. Or are you trying to write a query? Still not sure I get it.

 

[timbits35]

Hi,

I would like to use the fields TypeDisputeID and ResultID as foreign keys in 2 different tables. They are currently being used in the main table tblCase and they are both combo boxes.

I would now like to also use these fields in another new table I am creating as explained above. They would also be combo boxes.

I am not sure how to explain it any other way. Does my analogy with the provinces table not help?

Thank you.

 

[MarkK]

I would now like to also use these fields in another new table I am creating as explained above. They would also be combo boxes.

You would like to? What happens when you do? Does it work?