Autofill Problem

[toner321]

Im ready to give up! I cant get this to work for snot. I have 2 diffrent table, one is 'equipment_types' and the other is 'add_equipment'. I need the Equipment type info [model, manufacturer, equipment type & ET#] to autofill the other columns when i enter the name in 'equipment_type:model' I have a few other thinks to link and would like to know if this is a portal, autofill or relationship type thing. I am very new and have tried for 6-7 hours to do this simple thing. I used to be smart but now im just stuck and ready to give up.

[bcooney]

You need two tables, Equipment and Equipment Types. The Equipment table will have a _kF_EquipmentTypeID and relate to Equipment Types by this ID.

Now, all you need to do is show the related fields from Equipment Type on the Equipment form.