![]() ![]() Instead, it is implicitly created and enforced by the use of relationships between tables, especially the relationship between a primary key and a foreign key. The one-to-many relationship is only a principle of database design, which cannot be explicitly defined in the database structure. This note is by way of a pointer to my application and hopefully it will act as a learning resource and encouragement to other. One, in this example, is one customer to many sales transactions. When I started to re-build my MS-Access application nine months ago using LibreOffice I couldn’t find any public examples where LO has been put to use in a fully functioning integrated application that made use of the MSQLDB database and the Base macros and writer. This logic is what is defined by the one-to-many relationship. A single sales transaction can only apply to one customer, but one customer can have many sales transactions over the course of time. The SALES table contains the CUST_ID foreign key, which references the column of the same name in the CUSTOMER table to track the customer to whom the sale was made. ![]() ![]() The SALES table: This is used for keeping track of individual sales transactions.The CUSTOMER table: This is used for storing customer master details.Techopedia Explains One-to-Many RelationshipĬonsider a database for recording sales information in a store. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |