Auto Dropdown value list (1 Viewer)

[Alejo]

Hi everyone,

Hope someone can help me on this task. I attached the Database for your reference with table and form only.

Query 1:
I have a combo box Item with dropdown values Item1, Item2 and Item 3. Would it be possible that when I selected Item 1, the combo box "Distribution" will display only the items A1, A2 and A3? and Item2 and Item 3 should have only the below values?

Item1 = A1;A2;A3 Item2 = B1;B2;B3 Item3 = C1;C2;C3

Below is the screen shot.

Query 2:
After filling up the textboxes for Item, Distribution and Note...is there a way that another set row of Item, Distribution and Note will display.
Every time values were added to the row, new rows for Item, Distribution and Note will show up..
(Text boxes Vendor and Date1 are not included in the new row display)

Thank you for your help

 

[Gasman]

Put the data for the combos into a table and use cascading combos for Q1
The data for Item, distribution and Notes are held in another table for Q2

 

[Alejo]

Put the data for the combos into a table and use cascading combos for Q1
The data for Item, distribution and Notes are held in another table for Q2

Got the solution for Q1 thanks
For Q2, I don't get what you meant, can you explain further

 

[Gasman]

Well I am assuming Q2 is creating records with fields for those items?, So as you complete one record, another is created if you tab through the controls?

 

[Pat Hartman]

If you want the form to show multiple rows, use a continuous form. If you have a parent/child relationship, bind the main form to the parent table/query and add a subform for the child table/query.

 

[arnelgp]

put Item and Distribution in separate tables.
create a Junction table for the two tables.

 

[Alejo]

Hi Gasman, Pat, arnelgp,

Regarding Q2...
After Filling up Item, Distribution and Note, new set of those field will appear and it should be on the same ID number. (not sure if this is allowed in access). There were cases that the Vendor delivered more than 2 items ( its not fixed), which means if the item delivered is only one, no need to have the additional auto rows.

*******************************************************************************************************************************************
The main reason for the Q2 request is to have a form that can more info on Item, Distribution and Note on the same ID.
And at the same time we can have a report the will display as below. (this is format from excel)
I'm not sure as well if auto merging is allowed in access if not, at least close to it.

I attached the Database3 with additional Report for reference.
This is the database I created using the cascading combos (almost same as the one attached by arnelgp but a simple version)

 

[arnelgp]

see this sample.

 

[Alejo]

see this sample.

hi, I noticed you added new tables, Queries and Forms..
I'm trying to understand the set up, are all below files required or which one I can remove

 

[Alejo]

hi, I noticed you added new tables, Queries and Forms..
I'm trying to understand the set up, are all below files required or which one I can remove


View attachment 93216

hi arnelgp,

I'm creating report wizard to display the items Vendor, Date, ITem, Distribtuion and Notes but an error occur as those items are not all connected to each other, may I request you to edit the same file you did addition of Report with the mentioned items on it.

Thanks

 

[arnelgp]

see another sample with report

 

[Alejo]

hi arnelgp.

Thank you very much for the design database.
It might be different to what I am expecting but its close to my target result and I can use it. The report view is okay.

I created a split form called "Mainform" (below screenshot) and a button New for new transaction.

I just want to raise questions on the below display before closing this request, would it be possible as per below screenshot that the date 26/07/2021 and Vendor should be merged in one row only as it is one record only? but the Item, Distribution and Note retains as it is? And on the top view should display all information for the record (current display is just Item1 , Item2 and Item 3 are missing)

I attached updated database with Mainform.

 

[Alejo]

Thanks arnelgp