Need help enhancing a form...

[fallen851]

Hi there,

I'm in a class with an Access database project in which we create a database (using Access 2010) for a manufacturer of cell phone cases. Everything has been going great, but the usability of my forms isn't where I want them to be.

Basically the issue I am having is that the form I created (pictured below) that shows the cell phone case, what phone it fits and a description has a table (Case_Part) that lists the part ID's for each part that makes up the case.

I want that table to also list the description and part name for each case part next to the case part used, but I've been totally unable to do it and I don't want to add data to the Case_Part table because then it would duplicate data. I added another table (Part ID) with the parts below, but it requires the person using the form to scroll down to figure out what each part is if they don't know what part each part ID corresponds to.

Is this possible in Access 2010 without duplicating data? I assume it is something I need to change in my relationships table or something I'm not doing right in design view.

Thanks for any and all help!

 

[ct2013]

Ensure your relationships partID are all connected correctly, then create a query and insert the two tables, then select the field from both tables you want in your query and that should do it!

 

[fallen851]

Thanks for the response.

I did that, but ended up with the same basic thing (see below) unless I did something wrong. I want it to only display the part name and description for the parts used. There are over 20 parts that fit in 6 phone cases, and some parts are used more than once.

Running the query showed all the part names and descriptions for all possible parts. In other words, I want it my form to show only the part names and descriptions for the parts used for that case. Note the Case ID.

 

[fallen851]

This is what I am looking for:

Each phone case (Case ID) has 4-5 parts, and I only want the list of parts required for that phone to be in the table.

As it stands now, it only shows the Part ID and Case_Part ID (from the Case_Part Table) for Phone Case 1, but I want the part name and description from the Part ID table to show for all the parts that make up Case 1.

 

[ct2013]

not sure do you want to send the db over

 

[stopher]

Not sure how you've created your form. But the key thing is you need to ensure the following properties for the subform are completed correctly:
"Link Master Fields"
"Link Child Fields"

For both properties I'm guessing you need CaseID (the field that is common to both data sources). You can check these by right clicking on the subform and edit the properties manually if necessary


To explain from the start:

• Create a main form based on your parent data
• Create a separate subform based on your child data source
• drop the subform onto the main form. this normally opens a dialogue box suggesting the parent/child links

You don't actually need to create a subform because if you drag/drop the child table onto the main form, a subform will be created for you with the same effect.

hth
Chris