🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.mac.databases
Article #633

4D Auto Assign Related Value Ain't Workin!

#633
From: Jeff
Date: Thu, 21 Jan 1993 08:16
57 lines
2720 bytes
Please appreciate this is almost a last resort and that I have read the
manuals and discussed this with ACI already. I'm hoping that someone can
help me with a question about automatic relations and auto assign related
values. I will keep it as simplified as I can:

I am creating a database for a Newsletter. I have two files, Clients and Ads.
Clients is the one file, Ads is the Many. Each Client can have many ads, only
one client per ad... simple.

Clients have a client number, and I use it as the relational field between the
two files.

Clients has an input layout with an included layout for Ads file. I understand 
that the auto assign features only work if you use command-tab, or Add To 
Included button. 

The Client field uses a #N to increment the field and assign an integer to it.
I have this only in the [Client]Client_Number layout field, not in the [Ads]
Client_Number field, since this value should be spawned once, then auto assign
ed to the related field in Ads;Clients, right?

So during data entry, I want to add a name and address in the client
input layout, then hit the Add to Included button and have the client 
number in the current 
record carry across to the new Ad record, but it is not being
carried across not matter how I try it. 

I have:
selected Relate One and Relate Many in the Relations dialog between the
two 
files, as well as the auto assign related value.

I have the [Ads]Client_Number Field in the Ads layout assigned to
[]Client_Number in the Field Dialog when I double click the 
[Ads]Client_Number field.

I have not used #N in the [Ads]Client_Number field, because I am
expecting this number to be auto assigned during data entry; carried
across from the [Clients]Client_Number field where the integer was
created.

This is supposed to work, but does not. Any ideas why?
I can't find an example database, tutorial, etc. that demonstrates
this!

(4d Tech sez, "well, then do it with a variable.")

If not, then how could I do this with a variable? 
If I don't do it with the correct proceedural controls, then [Ads]Client_
Number gets set to what ever the current record is, not what 
was in [Client]Client_Number when the record was created, and things 
get really hosed. I assume I would use a process varable?

Lost in CyberSpace,

Jeff-
Technical Details
Message-ID: <1993Jan21.081628.15195@netcom.com>
Path: arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!uwm.edu!spool.mu.edu!agate!stanford.edu!kronos.arc.nasa.gov!butch!netcomsv!netcom.com!jeffp

Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.databases
Path: arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!uwm.edu!spool.mu.edu!agate!stanford.edu!kronos.arc.nasa.gov!butch!netcomsv!netcom.com!jeffp
From: jeffp@netcom.com (Jeff)
Subject: 4D Auto Assign Related Value Ain't Workin!
Message-ID: <1993Jan21.081628.15195@netcom.com>
Organization: BeHereNow
Date: Thu, 21 Jan 1993 08:16:28 GMT
Lines: 57