Animus | A crowd simumlation featuring GPU

UPDATE: If you read this entire post and understood it for your own reason, the answer is obfuscated in the average person's design concept with regards to their database design, not how Access works. It took months to get this concept and I'd like to pass it along.

First of all, the autonumber type updates at the end of any save function or command of any kind, even keyboard input in datasheet view, to a record in that table, period. Doesn't matter how many new records you don't have to code this at all, and if it's not working it's in a form, not because your table isn't working (barring some corruption). In forms, when building your form begin with the main table autonumber primary key as the recordsource and use your form, for more elaborate results base the form on a query or use subforms. In addition to the recordsource, decide whether your data entry form is subform related (can you use a subform if so is it related to the main form? or a separate data entry form)

Lastly, in my one to zero or one scheme, you don't always have to join at the table level to update both tables at the same time, I was very confused by this concept and thought I didn't understand other posts relating to the matter. But it seems to me that a lot of answers on this and many other forums are not full attempts at helping other people understand as much as the OP, which is why it was frustrating, as seemingly no one was approaching my particular problem in any other posts, and why even the help I got was limited to one earnest person, shoutout to Wolfgang.

There are so many posts and posters approaching this question from so many angles that I couldn't really find the answers I was looking for. what worked for me may not work for you in keeping your data input connected, I used a combination of joins and queries to achieve what I wanted, but I could not have done it without understanding some of the above, once you get YOUR concept don't endlessly search for forum posts for answers without your search involving answers to specifics. It did not help very much to post a question, read more about the names of the items and capabilities in Access and ask a question to solve a general problem, not too specific. You will see posters ask for more info in order to help you. I clearly posted exactly what I wanted and I got scolded. I hope this helps, peace to everyone and ALL - CJ

PS dear experts, your help is appreciated in the time-saving nature of having forums and discussion in the first place, and also is mined for usefulness, not street cred. get helping or get off. The time I wasted reading posts where the answer was "I don't understand what you are trying to do..." and then questioning the OP with animus or incredulity, or suggesting some unrelated answer further confusing issues, is seemingly the problem with the world these days, if you want to help, help

Original Post:

Ok so as per the comments, thanks to ANYONE who volunteers any help with this problem.

I have a table and relationship design problem.

I have a table with a pk auto and I want to have a related table with a related column incrementally numbered that updates every time new data is entered in the form that is bound to it. It needs to update the related rows in the autonumbered table's key.

---the answer was to join the table on the autonumbered field.

The autonumber of the first table (main recordsource) is just an ID. I think I need two Primary Keys as I need to update the related record with that number in the entry form and move to NextRec but update the pk in the main table and move to NewRec , how do I join (see jpg image)?

I want enter results and update that existing record but update the adjoining pk so that a new record is created in the main table.

Tourney

more in depth:

From yours

My desired form

note that the calculation table feeds the upcoming games table, where a query shows the players recent results. I would like to split the upcoming results to show the players' recent game history, the second tab I would like to enter either one result or many results at a time. I hope I am clearer. You can see why I have had a challenge. See my form though. The recordsource is the upcominggames table and the data entry form is for input (ENTER GAME DATA)

-----the answer to this was an update query (a separate form) and then requery the statistics form to show the new matchups that were entered.

For install matplotlib in windows 10 64 bit machine get error showing

I want to add html i tag to substring in a string to those matched to the element of the array. If the matched substring has i tag then don't add else add. here's my sample code.

Given I have the following XML

When I try to install my package

I am playing around with promises and API calls, this time with https://www.warcraftlogs.com/v1/docs. The goal of this example is when you click the zones button all the zones will show up, and allow you to click on them (that part is done). The next part is to show detailed information about a particular zone when clicked, in this case the encounters array in the zone object.

Here is the pen in question: http://codepen.io/kresimircoko/pen/ZLJjVM?editors=0011.

The question is how to access the encounters array for the zone that the user has clicked on?

And the code: