ContributionsMost RecentMost LikesSolutionsRe: Populating form field with selected values from shared fieldOkay - I got it working by building a relationship and using the list report but I must admit I'm not really comfortable with it. I agree with your comments about design and have it structured accordingly. All I'm trying to do is to store in a separate table unique information about a particular Company if they are of a particular Company Type. I could include the fields in the Company table but I have an aversion to having a fields in a table that are not applicable to all the Companies in that table. Re: Populating form field with selected values from shared fieldAnd this is where I do get confused with regards to how QB is using relationships. I understand that one Company can have many contacts and one Company Type can have many Companies. For this table, I only have 1:1, if the Company is a CAT dealer (as designated by the Company Type), then they have one record in this table. If I create a relationship, then is it one CATDealer to many Companies or one Company to many CATDealers? Neither seems right to me. Maybe Sam's approach is the most efficient?Re: Populating form field with selected values from shared fieldAppreciate the offer - may have to take you up on that but don't want to waste your time. I feel like I'm not making the assignments in the correct places. The setup here is so different from what I'm used to in Access. Re: Populating form field with selected values from shared fieldOkay QBCoach, I think your approach is the way to go but having some difficulty executing. I created the relationship between to have one Company Type to many Companies. Within the settings of the Company Type table I can create reports and filter on Company Type to see only the types I want to see. Now I create another table to contain the special info I want to capture. Now I move to the form/table for the special info I'm storing. I open that form and select the Company Name , I can't seem to find where I select the report that filters just the Company Types I want to see. For that matter, don't see where I can assign a report to a drop-down list at all - only see where to assign a field source.Populating form field with selected values from shared fieldI'm in my evaluation period and have a question. I've built a Company and Contact table and related them. The Company table includes a field - Company Type. All good. Now I'm working on another form (say Form A/Table A) which will collect information on a Company but only for a particular Company Type. In Form A, I have a Company Field and set the input to that field as the Company Name from the Company table. However, I only want to see Company Names that have a specific Company Type. There will be only one record for each Company in Table A. My background is more Access so I'm still trying to unwrap my mind from those particular conventions. Thanks.