B
Billp
Hi,
I have a form which I wish to be able to display in a control on it, another
forms current revision number.
Works form can have a Packingslip form raised against it, the two froms are
related by the WorksNumber. The Works Card is open I would like to view the
current Packing slips field called revision. I have tried to use a sub form
with the packslip revision only showing and then relating this to the Works
card - didn't work. I thought of trying an uncontrolled text box but couldn't
work out how to link it to the Packing slip form number and the subfield
Packing slip revision. If I write a simple query based on the Pacaking slip I
can get the revision to show if I enter the Works Number as a criteria - but
I am lost as to how to implement this on the current Works Form.
Help would be appreciated - guidance apprecaited.
Thanks
Bill
I have a form which I wish to be able to display in a control on it, another
forms current revision number.
Works form can have a Packingslip form raised against it, the two froms are
related by the WorksNumber. The Works Card is open I would like to view the
current Packing slips field called revision. I have tried to use a sub form
with the packslip revision only showing and then relating this to the Works
card - didn't work. I thought of trying an uncontrolled text box but couldn't
work out how to link it to the Packing slip form number and the subfield
Packing slip revision. If I write a simple query based on the Pacaking slip I
can get the revision to show if I enter the Works Number as a criteria - but
I am lost as to how to implement this on the current Works Form.
Help would be appreciated - guidance apprecaited.
Thanks
Bill