To start off, i have no coding experience =)

i have form Shipping and form Freight

form Shipping has field Invoice# and Total Amount

When in form Freight this is the scenario that i want.

1.Lookup field called Invoice to retrieve drop down lists of Invoice# from shipping ---accomplished

2.field called Amount to retrieve the CORRECT Total Amount corresponding to the said Invoice, no dropdowns. -- fail 

Thanks in advance i hope someone helps me out =)