subform not entering master linked field number

[swingkyd]

I started with a question here which I abandoned based on the solution not going anywhere. The problem changed to a foreign key error in the database backend. But the real problem seems to be the subform that I created. I followed the various threads here about creating subforms from
DrewJensen found here and the "getting started" guide.
So I think I narrowed the problem down to the following:

• Created a master-subform with a database
  
• linked the field ID of the master form to the field to be linked in the sub form
  
• with data already entered using other methods, the data shows up in the subform as expected. I can modify and delete records without any problems.
  
• the problem is entering new data. two things seem to be happening:
  

1. The auto field is not incrementing in the subform (if I use the form only for the data in the subform, I can add stuff without problem)
   
2. The linked field which originally showed up as the correct linked number (ie. it was 290 which corresponded to the ID of the master field I was looking for. This is also an autonumber field.) was replaced with "zero" for some reason.
   

I think the latter is what was causing the foreign key error (I disabled the foreign key to discover that).
So does anyone know what might be causing the form to not enter the 290, rather it enters the 0?
[edit] point 1 is not a problem. the autoentry field does post the correct ID. The problem is point 2. I included some screenshots of the behaviour. I hope this helps.

[swingkyd]

I thought I should link some images so people might get an idea what is going on:
Here is my Form Properties for the subform:

Followed by a screenshot of the form with data already entered using other methods.

And then I enter information: (Note, the code 290 is entered here)

Then finally, after the data is entered, this is the problem with the "0" entered. If I hit refresh, the line entered seems to be zero and not 290. I do not understnd why this would be.

[swingkyd]

Hey everyone...so would anyone know if this behaviour requires an issue being filed or am I just missing something fundamental here?

[DrewJensen]

If this is a MySQL backend then there is already an ISSUE entered. Also a work around.

If it is an embedded database, then yes you should enter an issue.
_________________
Blog - http://baseanswers.spaces.live.com/

[swingkyd]

[DrewJensen]

yup that is it....
_________________
Blog - http://baseanswers.spaces.live.com/