Greetings,
First I will say I am an Access novice. This is my first project. I have limited database experience with other programs. This project is for color matching in a printing business. It is a color matching request form.
Currently, my database has two tables called "Main" and "Inks" and I have forms for both, with the form for the "Inks" table in "Datasheet" format. The Inks datasheet form is shown inside the Main form (would that be called a sub-form?).
My Inks table includes a field I called "Request ID" which is linked to the Main table's automatically generated ID number. The Main form is the "top level" of the request. The Inks table has multiple records, and they are tied to the Main table's automatic ID.
Customer info such as name, part number, etc. is entered in the Main form. Then, names of colors (red, green, black, etc) are entered in the datasheet for the Inks table, in a column called "Colors"
I have another column in this Inks datasheet I called "Prints Behind" in which I want to list all the entries made in the column called "Colors". They should be listed with a check box, allowing the user to indicate, within a single row, what other colors are printed behind it.
My problem is that I need to limit what is displayed in the "Prints Behind" field of the datasheet to those colors listed for just the current record. Instead, I am getting all colors for all records.
In the Inks datasheet, how do I display the contents of the column called "Colors" in a Combo Box called "Prints Behind" for the current "Main" table record?
Sorry for the length of the description, but hopefully I have explained myself adequately. I appreciate any and all help, and your patience in dealing with a novice
Thanks,
Mike
First I will say I am an Access novice. This is my first project. I have limited database experience with other programs. This project is for color matching in a printing business. It is a color matching request form.
Currently, my database has two tables called "Main" and "Inks" and I have forms for both, with the form for the "Inks" table in "Datasheet" format. The Inks datasheet form is shown inside the Main form (would that be called a sub-form?).
My Inks table includes a field I called "Request ID" which is linked to the Main table's automatically generated ID number. The Main form is the "top level" of the request. The Inks table has multiple records, and they are tied to the Main table's automatic ID.
Customer info such as name, part number, etc. is entered in the Main form. Then, names of colors (red, green, black, etc) are entered in the datasheet for the Inks table, in a column called "Colors"
I have another column in this Inks datasheet I called "Prints Behind" in which I want to list all the entries made in the column called "Colors". They should be listed with a check box, allowing the user to indicate, within a single row, what other colors are printed behind it.
My problem is that I need to limit what is displayed in the "Prints Behind" field of the datasheet to those colors listed for just the current record. Instead, I am getting all colors for all records.
In the Inks datasheet, how do I display the contents of the column called "Colors" in a Combo Box called "Prints Behind" for the current "Main" table record?
Sorry for the length of the description, but hopefully I have explained myself adequately. I appreciate any and all help, and your patience in dealing with a novice
Thanks,
Mike
