Delphi Editable PivotGrid to manage a ManytoMany Table

This project is to create an EDITABLE Pivot Grid for end user to edit.

Background:

We want to be able to give for our customers some items for free. Each customer could have more than one item and the quantity could also be more then 1 per item

We start out with 3 files

a. Customer //PK=TEL

b. Products // PK=CODE

c. ManyToMany (file called TMCH)

Now instead of having the end-user deal with the many-to-many file We would like to use an editable Pivot Grid should update the underlying tmch table

One can also ADD or DELETE a customer or a product and all relevant rows needs to be added or deleted from to the ManyToMany table

Program to be written in Delphi

Database is Advantage Databases Server

Post proposal, include word blueMagic.

I’m including a link with tables and small program source to use as a test-bed/demo

Written in FD and including the ADS dll's neded to run

Also is included in the link a exe someone stared, but never completed and vanished

[login to view URL]

Delphi

ID Proyek: #23940866

Tentang proyek