Form Based on SKU Category

[HansBades]

I have a table for SKUs that includes the ID, Name, Description, and SKU Category ID. Of course there is another table for SKU Categories. Each SKUID must have a corresponding SKU Category it falls into. I am trying to create a form so that someone can use a combobox to drop down the particular SKU Category Name and then load at once many new SKUs that would fall under that category. I tried to setup the form with a datasheet view but I can't get the combobox to work so that whatever they enter is attributed to the particular SKU Category. Any thoughts? thanks.



SKUID
SKUNAME
SKUDESCRIPTION
SKUCATIDFK

SKUCATID
SKUCATNAME
SKUCATDESCRIPTION

[kd2017]

There's a lot of ways to skin this cat. The quickest way would be to create a form based off the SKU categories table, then on that form place a subform for the SKU item table and link the skucatid is the parent related field and skucatidfk is the child related field. Then any skus records you create in the subform will automatically be linked to the SKU category currently in the parent form.

[HansBades]

Thank you. I did that and it worked.

[HansBades]

I have the subform in datasheet view. Is there any way to copy and paste multiple skus at one time?

[ArviLaanemets]

I have the subform in datasheet view. Is there any way to copy and paste multiple skus at one time?

Recreate the form used in subform (NB! Subform is a container control, which has a form as Source. By default Access use the same name the form has as subform name too - I myself always rename the subform to avoid any possible future confusion. Eg. the form is named fFormName, the subform based on this form is named sfFormName.) as continuous one.

When you create continuous form instead of datasheet one with same name, then probably this is all you need to do. When the names differ, you have to edit the Source of subform. And in case you delete the old source form of subform through the process, to avoid any error messages popping up, don't activate the parent form until the new form for subform is ready!