selection in Combo box that auto select two other fields in the same row of a table.

[johnseito]

I have a table called Auction, it has three fields, seller, iid, and start_time.



I made a combo box on a forum and in the I have a query,

My question is, I have a few combo box, can I have a user select a seller, but it will automatically populate in the same row, the iid and start_time for this seller?
How do I do this, I can't have separate combo box and have user select for each seller, iid and start time because it wouldn't match it to that seller on the same row.

I hope you know what I mean.

Please let me know. Thanks a lot.

[pbaldy]

Like this?

http://www.baldyweb.com/Autofill.htm

[johnseito]

that's good. Thanks. I tried it and it does what it suppose to. :-)

[pbaldy]

Happy to help and welcome to the site by the way!

[johnseito]

thank you, glad to here. :-)