by renz » Tue, 08 Feb 2000 04:00:00
Lorenzo Hale
by Paul Brunea » Tue, 08 Feb 2000 04:00:00
> I am attempting to create a database for unit personnel in which I need a
> field to list all past assignments an employee has had for the duration of
> his career. Do I use a repeating field for that, or is a different method
> recommended? All help is greatly appreciated.
> Lorenzo Hale
by renz » Wed, 09 Feb 2000 04:00:00
Thank you. If I want to display this info., would you reccommend using a
lookup field, or a portal?
Lorenzo
> > I am attempting to create a database for unit personnel in which I need
a
> > field to list all past assignments an employee has had for the duration
of
> > his career. Do I use a repeating field for that, or is a different
method
> > recommended? All help is greatly appreciated.
> > Lorenzo Hale
by Paul Brunea » Wed, 09 Feb 2000 04:00:00
I would use a portal, but it might depend on what your system is like. A
rule of thumb is:
-If you want changes in the related file to be instantly seen in the
main file, use a portal
-If you need to preserve the original information despite later changes
in the related file, use a lookup
(a common example of this is invoice line items. You don't want the
price of an invoice line item to change if your pricelist changes)
PB
> Paul,
> Thank you. If I want to display this info., would you reccommend using a
> lookup field, or a portal?
> Lorenzo
> > I would certainly avoid the use of a repeating field for this purpose.
> > Consider creating a related file called "assignments" or something that
> > links to the employeeID. It will let you have as many or as few
> > assignments as you will need, whereas with repeating fields you will
> > always be asking yourself "How many assignments should I plan ahead for?"
> > > I am attempting to create a database for unit personnel in which I need
> a
> > > field to list all past assignments an employee has had for the duration
> of
> > > his career. Do I use a repeating field for that, or is a different
> method
> > > recommended? All help is greatly appreciated.
> > > Lorenzo Hale
1. Merge normal fields into repeat-field
Hi c.d.f,
Due to a design error I've got a lot of fields, lets call them m1, m2, m3,
m4 that should now become lines in ONE repeat field mAll.
How do I go about this? I found how to extract stuff _from_ a repeat field,
but cannot figure out how to write to it...
Thank you in advance.
Hannes
2. Custom rollup formula for average
3. Layout Question - Advancing through unshown fields of a Repeating field
4. Should I convert db from Access 97 to Access 2000
5. Transferring related fields to repeating fields...
6. US-BOSTON AND SUBURBS PERM. ORACLE POSITIONS AVAILABLE-RECRUITER
7. Importing into a repeating field from several fields
8. Enterprise Manager, SYSDBA login problem
9. Change repeating fields into individual fields?
10. Split repeating fields to seperate FIELDS (not records)
11. Can calculation fields be repeating fields?
12. I need to get all values of Repeating field from calculation fields
13. converting related fields to repeating fields