Everyone Hi. A relationship problem I'm having for her help I need. My scenario is as follows. Car running buses var.Bu tools to companies and factories Personnel taşıyorlar.Otobüslerin distinct, separate unit prices var.Sabah and Evening fee in the form of fees alıyorlar.Bunların accounts and To keep the accounts of the companies they do business and a table how do I need to build relations.

Nuri

1.Tablo Example: Tour

2.Table: Charter Buses

3.Table: Services of the Company or Factory

Hi Nuri having a wee bit of trouble in understanding your needs.

First I am thinking you might gain benefit by some online FileMaker training.

That will give you a 24 hours pass at Lynda.com and you can review the FIleMaker training videos

http://www.lynda.com/promo/freepass/Default.aspx?lpk35=930&utm_medium=affiliate&utm_source=ldc_affiliate&utm_content=655&utm_campaign=%ADD_CODE&bid=655&aid=CD675&dp=2625&opt=

Second it looks like you need a set of keys as follows.

Table: Tours Parent Key: Tour ID = Tour ID on Child Table: Buses

Thinking is that you would add a bus to the tour.. you assign the bus to the tour by attaching the Tour ID to the Bus record.

Services can tied in by the Bus ID and The Tour ID in a similar manner as above.

If you need more detailed help feel free to post to me or go to our website:

http://www.terrasoftware.com

We can setup a screen share and go through it if you need to.

Thank You