attempting complex trade entry ticket system with multi legged transactions

[DirectCommodity]

Hello!

Pardon my noob-ness, but i am completely lost trying to create a simple small desktop database for commodity trading business.

I am attempting to create a database that does the following items on a desktop application?? Maybe wrong word.. here is what i need to occur, please tell me if I am in the right place or not.

Short example added here in attachment:



The example is 1 market WTI-Cra / WTI-MID which is actually 3 separate "tickets" or rows with trade reference numbers.

Ticket 1= WTI-Cra / WTI-MID ( Buyer buys WTI Crane and sells Midland WTI crude oil) Seller does the opposite ( Sells Crane Buys Midland)

Ticket 2 = WTI Crane

Ticket 3 = WTI Midland


My question is, How can i setup my database table , form, etc for multi tickets and single ticket trades ? I want my system to automatically add the required amount of lines of trades for those single or multi ticket markets based on what market is selected in the Deal Entry Form

Does this make sense or no?

[mike60smart]

Hi
Not knowing anything about Commodity Trading it would help if you could explain in very simple terms the process of 1 Trade?

If I was explaining the process dealing with the purchasing of items it would be along these lines:-

A Customer on a given date buys a number of Items.

This would result in the following tables.

tblCustomers - contains all fields about the Customer
tblPurchases - contains fields to link Purchases to Customers as well as a Purchase Date
tblPurchaseItems - contains a field to link Purchase Items to Purchases as well as ItemName, Qty, Price

[orange]

You may get some insight on stock trading design info from this material.