4 way form...

[Canderel]

Hi... I have a database, which seems very simple at first, but now when I want to create a UI that's easy and simple, it's not working properly.

Background:
There is going to be used at a games convention. There can be players, and Game Masters (GM's). Each player and GM is assigned to a team. Each player will play in X games. Each game will have a different time and one GM, and several players. A game will be linked to a table, though this is not essensial.

Anyway, I've got the database structure figured out (or so I think).

What I want to do is to have a registration form, which should have a couple of tabs:
1) Player Tab ... For entering a new player. (Name, sex (dropdown), payed, team (dropdown)) This tab must also have a list of games, so the player can decide which games he wants to play. (I thought of a listbox where multi select is enabled)
2) GM Tab ... Almost an exact clone of the player tab, except that it will now be applicable to a player.
3) Team Tab ... If a player wants to enter, but his team hasn't been registered, the user can just quickly create the new team.

I am struggling to make this work.

 

[Canderel]

I got it to work eventually. I often find that just typing down my problem gets me thinking of what exactly the problem is.

The problem that I had was that my 'players' tab would show #Name? or similar when I looked at the form.

Most of my editboxes had the #Name? error going. But they were bound, and the form is actually used for input. So I just made them unbound, and sql'ed them into the appropriate table when I pressed the input button.