Search results

  1. A

    Joint Table Primary Key

    In a many-to-many relation, one create joint table and use two columns of both ID's in a Composite way. This what the text books recommend. I had a Form/subform to view the relation between the two table. I tried to add to the subform a new relation Access did not allow me to do it. I can go to...
  2. A

    Form to Select records without VBA

    The table has PK and city column can be one of several. I need to create a filtered datasheet view (few columns only) Since there are quite a few cities, I need to select one to display all the records in that city. My questions Since it is a datasheet view I cannot use Combo Box. What to do...
  3. A

    Create proper relations

    I have the following tables: 1. Client Table 2. Client Farms ( each client has one or more farm) 3. Client Crops (what the client produces, and the seasons they use) The products we sell have these tables 1. Products 2. Stresses the products cure ( Product can cure more than one...
  4. A

    A very large table and a solution

    I have a Contact Table that has data as huge as a contact in outlook ( many many fields). I decided to split it into groups and hence separate tables The Main table has the absolute minimum and also functional ClientID (PK) auto company name First/last name Mobile Then followed by...
  5. A

    Two appraoches in table design

    Tables client and product. It is many to many 1. Approach I Unique Client table and Unique Product table and Junction Client/Product table 2. Approach II Client with product FK, and Product with Client FK and the junction table. The nature of the project is; Clients will grow, but products...
  6. A

    There must be a better way to validate data entry

    I am auditing someone else Database. It consists of 4 entities and some associative tables. A MAJOR part of the tables (15 tables) are nothing but lookup tables to insure valid data entry. I call them reference tables. They are mostly STATIC.( City.... ). Whenever you design a form for data...
  7. A

    How safe using combobox to input foreign key

    In a Related Tables, you need to enter a FK to link to the other table. You either key in the FG from memory !!!!!! or use help. The standard procedure is to design the field as combo box AND use SQL to select the field that will help to input the ID of the other table. So, if you want to input...
Back
Top Bottom