This project is to create an EDITABLE Pivot Grid for end user to edit.
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]