?autofill fields with content from other tables?

[glzm0]

Hello again!

I want to know what I have to do if I want to autofill a field with content from other tables.

Ok here I try to define my problem a littlebit exactlier (sorry for my funny english)

Table A

fields: userID; userName; userPath

Table B

fields: userID; orderStatus; item

I choose in Table A the 4th record. Now I switch to Table B. If I make a new record in Table B, I want that automatic filled the field userID with the content from the 4th record of Table A field userID.

I dont want to add the userID by hand it should happend automaticly. What have I to do for this?

thx for any further help.

[transpower]

Make sure userID in Table A is connected to userID in Table B in your Relationships Graph. Then add a portal from Table B to the layout in Table A and allow new records to be created. Then whenever you add a record in the portal (in effect adding an item), the userID will automatically be added to the record in Table B.

It would be better to have these tables: Customer, Order, LineItem, Product. See Chapter 7 of Learn Filemaker 7 by Stars.

[Ender]

gIzm0,

If you're trying to tie newly created records to the user that is currently logged in, you might set a global gUserID, when a user logs in, then refer to that for newly created records (you could also tie things together with account names, if each user logs in with their own account.) An advantage of using a global to hold the UserID, is you can then use that for relationhips, to jump to related records that are tied to that user.