🚀 go-pugleaf

You have a pretty common problem. Here's a sample database that uses a
query to combine the fields necessary to provide "complete information".
Give it a try and if you have any questions, let me know.



Have fun!
-- 
Michael J. Hernandez
DataTex Consulting Group
Author: Database Design for Mere Mortals
http://www.ercb.com/feature/feature.0014.html
http://www.amazon.com/exec/obidos/ISBN=0201694719/

Bruce Collins <your_login@clear.net.nz> wrote in article
<63pcu0$qf9$2@fep4.clear.net.nz>...
> I have two tables called A and B.  Table A has a field lookup to table B
> which then fills in a couple of fields.  OK so far.
> Now I also have a form based on table A.  If the item I want to lookup
does
> not exist in table B I am stuck, so I have made a command button which
takes
> me into a form for Table B so I can add the new item.  The problem is
that
> when I exit the table B form the new item does not appear in the field
> lookup on the table A form.  If I then exit the table A form and come
back
> in again the new item appears OK.
> What am I doing wrong?  Is there someone out there that can help this
Access
> novice?  I am running Access 97
> Thanks in advance
> Bruce Collins
> 
> 
> 
> 
> 
> 
begin 600 Autolookup.mdb
<encoded_portion_removed>
end