ContributionsMost RecentMost LikesSolutionsreferencing record ID #s in related tablesYou will love this one. Trying to build an app that tracks vendor (partner) contracts which include services, number of units by service and pricing by service, then be able to have partners report on that each month so that we can reimburse them. So...I asked Chat GTP to write that for me. What I can't figure out is how to get the related Record ID # (which I assume is the ID referenced below for each table. For example Contract_ID or Service_ID) is to the related tables so that they tie together. I have created the relationships but they definitely are not connecting by themselves. Here is what I got back: To model this relationship in a relational database, you can create the following tables: Vendors: stores information about vendors, including vendor id, name, address, and any other relevant details. Services: stores information about services offered by vendors, including service id, name, description, and any other relevant details. Contracts: stores information about contracts between vendors and customers, including contract id, vendor id (foreign key to Vendors table), customer id, start date, and end date. Service_prices: stores the price of each service for a particular contract, including contract id (foreign key to Contracts table), service id (foreign key to Services table), price, and any other relevant details. Service_units: stores the units of each service for a particular contract, including contract id (foreign key to Contracts table), service id (foreign key to Services table), units, and any other relevant details. Here's an example of how each table might look with some sample data: Vendors: vendor_id name address 1 Acme Inc. 123 Main St. 2 XYZ Corp. 456 Market St. Services: service_id name description 1 Website design Design and build a website 2 SEO Search engine optimization services 3 Social media Social media management services Contracts: contract_id vendor_id customer_id start_date end_date 1 1 101 2021-01-01 2022-01-01 2 1 102 2021-03-01 2022-03-01 3 2 103 2021-04-01 2022-04-01 Service_prices: contract_id service_id price 1 1 1000 1 2 500 2 1 1500 2 3 1000 3 2 750 Service_units: contract_id service_id units 1 1 10 1 2 5 2 1 15 2 3 10 3 2 7 To track the monthly input of this, here is what was returned: This table would have the following fields: contract_id: the id of the contract (foreign key to Contracts table). service_id: the id of the service (foreign key to Services table). month: the month for which the units are being tracked. units: the number of units of the service used during the month. Here is a summary of what the relationships would look like between tables: Vendors to Services: one to many. A vendor can have many services, but each service belongs to only one vendor. Contracts to Services: many to many. A contract can have many services, and a service can be part of many contracts. This relationship is represented by the Service_prices and Service_units tables, which contain a foreign key to the Contracts and Services tables. Contracts to Service_prices: one to many. A contract can have many service prices, but each service price belongs to only one contract. Contracts to Service_units: one to many. A contract can have many service units, but each service unit belongs to only one contract. Services to Service_prices: one to many. A service can have many prices (through the Service_prices table), but each price belongs to only one service. Services to Service_units: one to many. A service can have many units (through the Service_units table), but each unit belongs to only one service. Service_units to Service_units_by_month: one to many. A set of service units can be divided into many units by month (through the Service_units_by_month table), but each unit by month belongs to only one set of service units. ------------------------------ Sally Andreatta ------------------------------ Re: Can't delete a form I literally found that right before you emailed me. That was after two hours of trying to figure it out on my own! Sally Andreatta Director of Contract Services 3215 Eaglecrest Drive NE Grand Rapids, MI 49525 Phone: (616) 222-7001 | Cell: (616) 881-8003 www.aaawm.org This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication is expressly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy any and all copies of the original message. Can't delete a formI am having trouble deleting a form. The red X box is grayed out and it is not the main form for the table. It is not used for any notifications either. What am I missing? Thanks! Sally A ------------------------------ Sally Andreatta ------------------------------