Please help simple problem

[Zartan]

I just need help doing a simple procedure. I need to create a sort of counter that will count how many times a serial number occurs... In a SEPERATE database file, and then pull the number into the other database - this needs to auto update everytime the number increases or decreases.

Edit:: I REALLY need help with this please PLEASE help me!

[QuinTech]

Hi, Zartan, and welcome to FM Forums! Please update your profile so we know what version you're using.

Create a relationship between Serial in the first file and Serial in the second file. Call that relationship, oh, let's say, SerialRelationship. Now the calc field Count (SerialRelationship::Serial) should give you what you're looking for.

HTH.

Jerry