creating an automatic stock number from another field

[eharris]

I'm working on a database to use for my own business. Is
there any way to automatically create text in a field
using part of the text from another field? I've been
trying everything I can think of.

 

[Rolls]

You need to set up a variable which temporarily saves the source text, then
stores it in the object location. \

However, relational design accomplishes this result for you, without the
necessity of creating special codes. Set up your relational table structure
correctly. Parent Primary Key fields become Foreign Key fields in child
tables.