I need to create Master Library

I have two tables one is book master contains id,name,author name, Isbn no, price, copies and other is Subscriber master contains id,subscriber name, and address.

Now I need to show Transaction details like checkin, checkout details of bookId, subscriber Id, Transaction date, date to be trurned.

 

How can I do this anyone, please help me how to do the transaction table to show the nentioned details...

 

Thanks in advance.

  • Ilamvazhudhi Sri Ranjani
    Now I need to show Transaction details like checkin, checkout details

    Do you have a table for this? 

    Ilamvazhudhi Sri Ranjani
    please help me how to do the transaction table to show the nentioned details...

    What does that mean? Please elaborate.

  • In reply to Kranthi:

    i created book table nd subscriber table.
    In transaction table i have to enroll the details with book id and subscriber id..

    I have to set validation like 1 subscriber can't take 5 book from the library.
  • In reply to Sri Ranjani:

    Like sales and sales line details, one sales order v have more lines...

    Like that one customer can take 5 books from the library and he cant take more than 5 books.
    How can i do the validation.
  • In reply to Sri Ranjani:

    how can i write validatewrite method for the above condition using count(bookid)
  • In reply to Sri Ranjani:

    You can have a maximum books to a subscriber as a parameter (or) set up on subscriber, so that you can do the validation. You can override aosValidateInsert on table and check count of books assigned to that subscriber with the maximum books allowed for the subscriber.
  • In reply to Kranthi:

    can you explain vth me coding?
  • In reply to Sri Ranjani:

    while select axsl where axsl.Book_Id==this.Sub_Id
    return axsl.Book_Id;

    throwing error as Function getbookid never returns a value.
  • In reply to Sri Ranjani:

    select count(RecId) from axsl where .........;
    if (axsl.Recid >= 5)
    {
    ret = checkFailed(strFmt("your error"));
    }
  • In reply to Kranthi:

    How to fill the date automatically in a field?
    I tried this code axsl.TransDate=DateTimeUtil::utcNow();
    its showing error
  • In reply to Sri Ranjani:

    DateTimeUtil::utcNow(); will return the dateTime type, use systemDateGet();
  • In reply to Kranthi:

    calculated the date, thank you
  • In reply to Sri Ranjani:

    now I have created number sequence using NumberSequencerefencecustomerclass, i wrote init and numrefbook id method in table, but i'm getting error as Reference for call of number sequences is not specified. please help
  • In reply to Sri Ranjani:

    i set refernce in ar module my edt is book_id is showing there but i don't know how can i make my numbersequence as B01, B02
  • In reply to Sri Ranjani:

    If possible, can you show what are all the changes you made in the form and table for this number sequence?
  • In reply to Kranthi:

    Ya I created number sequence now, I clicked the wizard in basic>numbersequence form. My edt get added there. And in general i set the format for my number sequence generation.

    Thank you all.
Related
Recommended