Create a new Table Question

[Bob]

I have a table that has 3 Coolum's
OwnerID
HorseID
OwnerPercentage

OwnerID and HorseID only give the ID Number
In other tables I have OwnerName and HorseName, how can I put:
OwnerName, HorseName, and OwnerPercentage together!

Thanks in advance.........Bob Vance

 

[Allen Browne]

Create a query, and in the query you can include all 3 tables.

In a form, you could use combo boxes for the OwnerID and HorseID, and set
Column Widths of the combos to the ID column is zero-width.

 

[Bob]

My table already has OwnerID ClientID OwnersPercentage
How do I match there Names to ID because there on a different table!
Thanks Bob

 

[Allen Browne]

1. Click the Queries tab of the Database window.

2. Click New.
Access opens a new query, and the Add Table dialog.

3. Add all 3 tables to the query.

4. Close the dialog.

5. Add as many fields as you want from all 3 tables.

In the query results, you can now see the names from the other tables, as
well.

 

[Bob]

When I try to create a qry from different tables access tells me I need a
wizard to do this , but just cant seem to get a qry from 3 different
tables..thanx bob

 

[Allen Browne]

The first option when you create a query is:
Design View.

 

[Bob]

Allen I am getting a no Relationship error..Thanks bob

 

[Bob]

I have 3 Tables
TblHorseDetails= HorseID,OwnerID,OwnerPercentage
TblHorseInfo=HorseName
TbleOwnerInfo=OwnersLastName, OwnersFirstName

What am trying to do is put these together except HorseID and OwnerID which
are there ID numbers
When I do put them together in a Qry , I get Every Owner with every Horse
with every percentage!
It is not reconizing the Indivual Owner,Horse,percetage
Thanks for your help, Bob

 

[Michael Gramelspacher]

I have 3 Tables
TblHorseDetails= HorseID,OwnerID,OwnerPercentage
TblHorseInfo=HorseName
TbleOwnerInfo=OwnersLastName, OwnersFirstName

What am trying to do is put these together except HorseID and OwnerID which
are there ID numbers
When I do put them together in a Qry , I get Every Owner with every Horse
with every percentage!
It is not reconizing the Indivual Owner,Horse,percetage
Thanks for your help, Bob

I would have 3 tables:

Horses
-------
horse_nbr INTEGER NOT NULLL PRIMARY KEY
horse_name VARCHAR (30)

Owners
-------
owner_nbr INTEGER NOT NULL PRIMARY KEY
last_name VARCHAR (30)
first_name VARCHAR (30)

HorseOwners
-----------
horse_nbr IINTEGER NOT NULL
owner_nbr INTEGER NOT NULL
ownership_begin DATETIME NOT NULL
ownership_end DATETIME
PRIMARY KEY (horse_nbr, owner_nbr)

This way you can have multiple owners of the same horse and ownership
over time. The current horse owner has ownership_end null. One of the
owners could buy out another this way too.

 

[Bob]

Micheal Most of the horses do have multiple owners, and the percentage
don't not have to add to 100% as I have ownership in a lot of them. If there
is a change of ownership I just change the owners at the end of the month so
it does not effect the invoicing of that month
, Is there not a simpler way that I can just see what owners own and there
percentages....Thanx Bob

 

[Michael Gramelspacher]

Micheal Most of the horses do have multiple owners, and the percentage
don't not have to add to 100% as I have ownership in a lot of them. If there
is a change of ownership I just change the owners at the end of the month so
it does not effect the invoicing of that month
, Is there not a simpler way that I can just see what owners own and there
percentages....Thanx Bob

Perhaps someone else here has an answer for you. Maybe even the way you
are doing it now is the best way for you.