Timewell — Sun, 28 Dec 2003 01:53:27 +0000

Right. A minor problem now. I have two forms set up. One is called Personal Details, the other is called Contracts. I have a button at the bottom of Personal Details that is linked to Contracts...on the contracts form there is a Contract_ID and a Player_ID. I want the button to link to the correct ID.

For example, I have a player with an ID of 125. I want the button to then link to the Contracts screen where the player's ID is 125, or to create a new record in Contracts that gives the Player an ID of 125 and a Contract ID of 125.

The ID's field type is Number - AutoNumber, I'm not sure if that will help.

Sorry for being a bit rushed, but it's rather late over in England!

Timewell — Sun, 28 Dec 2003 00:52:46 +0000

Its ok, I seem to have (somehow) solved it.

Thanks for your help here guys! I really appreciate it...so once again, many thanks! And if I have anymore problems, you'll be the first to know!

Timewell — Sat, 27 Dec 2003 23:56:44 +0000

Desktop Only

Suzanne — Sat, 27 Dec 2003 22:56:20 +0000

is this desktop only or web database with Access?

Timewell — Sat, 27 Dec 2003 22:49:33 +0000

Hmm...when I created a query but no data appears at all. I've clicked the Show button for all of the things I want. I am combining two tables, but that is possible.

I don't know if it isn't because I haven't specified a criteria. I've tried that but the Expression Builder just p*ssed me off!

So I only have three rows filled. The Field, Table and Show rows. For example:

Field: Player ID Contract ID
Table: Personal Details Contracts
Show: Ticked Ticked

If you need a screenshot, I'll get one.

Sorry to be a pest...and thanks for the help!

JeevesBond — Sat, 27 Dec 2003 21:05:30 +0000

Well, I just re-created what you're doing with 3 tables (one-to-many relationship from the first to the second then the same from the second to the third) and it worked fine.
Although, I do use the Lookup Wizard to define relationships in most tables...Access automatically creates a query for this, so I would imagine that's why it works. Am I correct Bob?

If so, you can use the Lookup Wizard to easily do what you need - good old Microsoft; so easy, until you need to do something useful

Timewell — Sat, 27 Dec 2003 16:46:07 +0000

I've taken some screenshots, that are attached below. Firstly, see Ex1.jpg.

As you can see there is a "+", you are able to click on this. When you click on this, it brings up a box (see subsheet.jpg). You can choose which of the tables you want but you cannot choose all of them. So when you click one you get expanded.jpg.

What I would like is that they are all viewable under the Personal Details thing at the same time, not one at a time.

If you could help, I'd be grateful!

Thanks!

JeevesBond — Sat, 27 Dec 2003 12:13:39 +0000

Quote: "when you expand."

Expand what? When you are viewing the tables?