Recent content by minez50

Please help Pat Hartman Thanks Pat, Im a very basic user and am still abit baffled about how to set the indexes for the multi-filed primary key and how this would enable me to achieve my outcome. Please would you be able to provide a more detailed explanation of the process. Much Appreciated!!

Please help, I have a form with a subform in it. The main form has a combobox, called vendor. The subform shows all software. When i select a vendor, i want only the software for that vendor to show in the subform. What I am trying to do is set up the link child fields and link master fields...

I am still not quite sure how to do this: table Application: Application ID TotalCopies 121......................................3 122......................................2 Now what i wish to do is create a new table, COPIES, which will have a primary key Copy...

I have a table with primary key, application ID ( this is autonumber type). In a new table i want the primary key, copy number, to take a value that consists of the application ID and add an autonumber to it. e.g Their are two copies of Application X which has an application ID of 19. so the...

The field vendor, is a primary key but i am not attempting to do anything with the key. All the i need to be able to do is choose a vendor from a combo box. Once that is chosen, my subform should display software that belongs to this vendor. Although i can do this, when closing the form or...

I have created a subform where you select a vendor from a combo box and this then allows you to view all software of the selected vendor in a tabular view. When I use this form and then try to go into design view or close the form, i get the following error message: 'The changes you requested...

Although your first sub form uses a similar concept, what i am trying to do is slightly different. I have a table called Software. In this table are various fields that identify a Application ID, Application name, vendor, software type etc. I have created a 1st form which shows the application...

Hi, Could anyone please help me! I am trying to create a sub-form which achieves the following. When you select a vendor from a combo-box, only the software that is manufactured by that vendor appears in a data-sheet form view. I have tried to create a secondary form which shows all the...