🚀 go-pugleaf

Michael,

I am sure you'll hear this from a host of others too. Please don't post
binaries to the newsgroups. Either e-mail them privately, are post them to
one of the binaries groups.
-- 

Arvin Meyer
onsite@esinet.net

Michael J. Hernandez <MJHernandez@msn.com> wrote in article
<01bce9d6$64908fc0$0d142299@godzilla>...
> 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
> > 
> > 
> > 
> > 
> > 
> > 
>