Article View: comp.sys.mac.databases
Article #6334D Auto Assign Related Value Ain't Workin!
From: Jeff
Date: Thu, 21 Jan 1993 08:16
Date: Thu, 21 Jan 1993 08:16
57 lines
2720 bytes
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!jeffpShow 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