Search results

Current design: Multiple tables and forms - Main form is "Contracts" Have the following subforms: ContractingInfo, PayingInfo, ActivityLog, and LineItemDetails --- all are linked to the "Contracts" table with PK and FK If, for example, I put the subform LineItemDetails directly onto the main...

Let me try this again --- Current design: Multiple tables and forms - Main form is "Contracts" Have the following subforms: ContractingInfo, PayingInfo, ActivityLog, and LineItemDetails --- all are linked to the "Contracts" table with PK and FK If, for example, I put the subform...

I have a database with approx. 15 tables and 7 forms. My main form "contracts" is for the general information about the contract. I then have several "subforms" such as Paying office info, Activity Log, Line Item Details, etc. If I put the subform on the main form, it looks terrible but...

that is correct. In my "Contracts" table (which the "many" side of the relationship), I have both a Primary Key "ContractID" and a fake key called "ContractTypeID" which is the primary key I the table "ContractTypes" (the "one" side of the relationship). In addition, in the ContractTypes...

Hello - I'm having an issue with my DB. Pretty sure it's a simple fix, but I can't seem to figure it out. I have a database with numerous tables. I have set up relationships between all tables (they are all pretty one-to-many relationships). I then created forms in which to enter and view...