Learn how all these data elements fit together:
This example features adding data about vendors and their invoices:
Table names | Vendors, Invoices |
Relationship | Vendor (one) to Invoices (many) |
Choice Field | Service – Values: Consulting, Licensing, Product, Other |
Vendor fields | Name, Description (multiline) Address, City, State, Zip Code Internal contact (lookup to user table) |
Invoices fields | Name (rename to Invoice Number) Date, Service (choice) Cost (currency) |