When I browse records with a layout using table A I want to display the name corresponding to a paddle no from table B in the layout header.
Your relationship should be:
Table A::Paddle no = Table B::Paddle No.
Enter layout mode on a layout for Table A
Use the field tool to add a new field object to the header.
Select Table B in the drop down in the specify fields dialog that appears.
Click the Name field from table B.
Now the field should show the name from the record in Table B with the same paddle no as the current record in Table A.
So how do I place Table A::Paddle no = Table B::Paddle No. into the script?
I already have the relationship set in the Edit Relationships dialog box.The field B:: name comes up blank. I know that B::paddle no =20 does have a B::name text.
Phil didn't mention any script. You do his instructions to design the layout in Table A. When you look at the record in Table A for Paddle Number 20 you will see the NameText that you have entered in Table B for Paddle 20.
Unfortunately it doesn't. Take a look at the image.
Your screen shot does not show the relationship that I suggested.
Aucton::Paddle number = Bidders 2::Paddle number AND
Aucton::Item number = Bidders 2::Item number AND
Aucton::Bidder = Bidders 2::Bidder Name
Aucton::Paddle number = Bidders 2::Paddle number
My relationship ONLY matches by Paddle number
Yours matches by the values in three different fields and there is no related record in Bidders 2 to match to the current record in Auction unless the values in all three fields match exactly.
And you do not need a field for the bidders name in auction if it exists in Bidders.
Yes that did it. I guess I was overthinking.
The next thing to consider is that you may need to also match by a field that identifies the auction if you intend to manage more than one auction with your database.
Well at first it looked OK. Then I reaized that the paddle numbers were not matching up to the bidder names. The first two were correct then the next was off by 2. It got even worse with higher paddle numbers. This makes no sense to be as table has the correct paddle numbers matching the bidder names. Any ideas?
Does your relationship just match by PaddleNumber?
Are both fields defines as type Number?
Does the Bidder Table only have one record for each Paddle Number?
On a layout based on the Auction Table if you place the Paddle Number field from it, and the Paddle Number field from that relationship (Bidder 2) do they always show the same Paddle Numbers?
Ther is no script necessary in any of this.
Only matches by paddle number.
both are type number indexed.
only one record per paddle number.
both paddle numbers appear the same andf the one I asked for.
Now add, beside the Paddle Number you placed from the relationship, the Bidder Name from that same relationship as the second Paddle Number. Do they look right?
If not, add a portal beside the Bidder name, using exactly the same relationship. Place the Bidder Name field in it (from the same relationship), and make it a 3-row portal. What do you see in the portal?
Doing the first the field comes up blank. Doing the portal comes up blank.
I exported the B table data into Excel. Everything looked fine.
I suggest uploading a screen shot of your relationship graph.
Here it is.