Hello I'm starting a new business and I need a database creating to display current standings.

I created a database during my college days using filemaker. This was about 5 years ago.

I would like the database published via my website and also give access to the database to the venues in my league so they can update their results as and when they get it.

As I am unsure of how to code in php and mysql I spoke to a friend who said if I create it via a GUI first he should be able to convert it.

I have since read of programs that are able to able to make these transfirmations.

Any advice on what I should do is truly welcomed.

I've just spent the last hour or so refreshing my memory on how to go about creating and using relationships. I seem to remember most of this.

Ok, I guess I should explain my situation.

I will be running a pub poker league where players in many pubs will play friendly games of poker against each other for points. I need to publish a league table online for players to see where their current standing in the league is.

I have 5 tables

Members

Venues

Tournaments

Seasons

Regions

Tournaments is the one where I'm having the problem.

In here should be stored the results for each tournament.

The fields I have in this table are

tournament id

date

total players

Each tournament will be assigned to a venue and here is my biggest problem, players will be assigned a position and a calculation for number of points earnt in that tournament.

I want to create a number of other fields in each record equal to the number of "total players" entered. So then I can call up member ID's and enter them in eg. "Position 1", "Position 2".

I am really stumped at this first hurdle and would really appreciate any help offered with this.

Thanks for reading

You need at least one other table, a Members-Tournaments join table where each record would have the fields Member ID, Tournament ID, and Position.

Hi thanks for taking the time to read my dilemma.

I have created this other table and called it points. I am now having a bit of trouble with an if function.

I'm trying to get "points" in the new table to be automatically calculated using the following formula

If ( Position = 1 ; Tournaments:Total Players*200/100*30 ; 50 )

Having played around with this for ages it seems that I'm not able to carry out a calculation from using the field in the tournaments database. So what is my way around this?

Also, how do I go about creating a graphical user interface? Do I create a seperate table with macros loaded onto it that simply point to the other databases that require information being input.

Please forgive my basic questions, I am a bit rusty.

You've got relate the Points table occurance to the Tournaments table occurance via the Tournament ID. Once the TOs are related you can use the Total Players field.

A GUI in Filemaker is called a layout which is based on a TO. You can shows data from the current TO or a related TO on a layout.

I have already related the fields and am able to call them correctly during the calculation but it always returns 0 when if x is true if I try to include the total players field as part of the calculation.

Also, what is a TO?

Can you post your file? It'd be way easier to diagnose that way.

TO is short for Table Occurrence.

Great thanks

Didn't know I could attach files.

Poker_League.zip

Seems to be working fine. What problem are you having?

You may want to make Points a calculation field rather than a Number field with an auto enter calc.

the points was displaying as 0 when I enter position 1.

I will try tomorrow (it's late here) and report back.

I was unaware of a calculatin option being available.

Thankyou

It works now I've changed it to calculation.

Thankyou very much.

What is a TO?

What skill level is needed in transfering this to a mysql database later on with php?

Edited July 21, 200817 yr by Guest

"What skill level is needed in transfering this to a mysql database later on with php?"

There is no way to "convert" FileMaker Pro files to MySQL. But hopefully, at least you've worked out the data architecture.